Struct GenericSqlWriter 

pub struct GenericSqlWriter;

Fallback generic SQL writer (closest to PostgreSQL / DuckDB conventions).

Implementations

impl GenericSqlWriter

pub fn new() -> Self

Construct a new generic writer.

Trait Implementations

impl SqlWriter for GenericSqlWriter

fn as_dyn(&self) -> &dyn SqlWriter

fn alias_declaration(&self, context: &mut Context) -> bool

Whether the current fragment context allows alias declaration.

fn write_escaped( &self, _context: &mut Context, out: &mut String, value: &str, search: char, replace: &str, )

Escape occurrences of search char with replace while copying into buffer.

fn write_identifier_quoted( &self, context: &mut Context, out: &mut String, value: &str, )

Quote identifiers (“name”) doubling inner quotes.

fn write_table_ref( &self, context: &mut Context, out: &mut String, value: &TableRef, )

Render a table reference with optional alias.

fn write_column_ref( &self, context: &mut Context, out: &mut String, value: &ColumnRef, )

Render a column reference optionally qualifying with schema/table.

fn write_column_overridden_type( &self, _context: &mut Context, out: &mut String, _column: &ColumnDef, types: &BTreeMap<&'static str, &'static str>, )

Render the SQL overridden type.

fn write_column_type( &self, context: &mut Context, out: &mut String, value: &Value, )

Render the SQL type for a Value prototype.

fn write_value(&self, context: &mut Context, out: &mut String, value: &Value)

Render a concrete value (including proper quoting / escaping).

fn write_value_none(&self, context: &mut Context, out: &mut String)

Render NULL literal.

fn write_value_bool(&self, context: &mut Context, out: &mut String, value: bool)

Render boolean literal.

fn write_value_infinity( &self, context: &mut Context, out: &mut String, negative: bool, )

Render +/- INF via CAST for dialect portability.

fn write_value_nan(&self, context: &mut Context, out: &mut String)

Render NaN via CAST for dialect portability.

fn write_value_string( &self, context: &mut Context, out: &mut String, value: &str, )

Render and escape a string literal using single quotes.

fn write_value_blob( &self, context: &mut Context, out: &mut String, value: &[u8], )

Render a blob literal using hex escapes.

fn write_value_date( &self, context: &mut Context, out: &mut String, value: &Date, timestamp: bool, )

Render a DATE literal (optionally as part of TIMESTAMP composition).

fn write_value_time( &self, context: &mut Context, out: &mut String, value: &Time, timestamp: bool, )

Render a TIME literal (optionally as part of TIMESTAMP composition).

fn write_value_timestamp( &self, context: &mut Context, out: &mut String, value: &PrimitiveDateTime, )

Render a TIMESTAMP literal.

fn write_value_timestamptz( &self, context: &mut Context, out: &mut String, value: &OffsetDateTime, )

Render a TIMESTAMPTZ literal.

fn value_interval_units(&self) -> &[(&str, i128)]

Ordered units used to decompose intervals.

fn write_value_interval( &self, context: &mut Context, out: &mut String, value: &Interval, )

Render INTERVAL literal using largest representative units.

fn write_value_uuid( &self, context: &mut Context, out: &mut String, value: &Uuid, )

Render UUID literal.

fn write_value_list( &self, context: &mut Context, out: &mut String, value: Either<&Box<[Value]>, &Vec<Value>>, _ty: &Value, _elem_ty: &Value, )

Render list/array literal.

fn write_value_map( &self, context: &mut Context, out: &mut String, value: &HashMap<Value, Value>, )

Render map literal.

fn write_value_struct( &self, context: &mut Context, out: &mut String, value: &Vec<(String, Value)>, )

Render struct literal.

fn expression_unary_op_precedence(&self, value: &UnaryOpType) -> i32

Precedence table for unary operators.

fn expression_binary_op_precedence(&self, value: &BinaryOpType) -> i32

Precedence table for binary operators.

fn write_expression_operand( &self, context: &mut Context, out: &mut String, value: &Operand<'_>, )

Render an operand (literal / variable / nested expression).

fn write_expression_operand_question_mark( &self, _context: &mut Context, out: &mut String, )

Render parameter placeholder (dialect may override).

fn write_expression_unary_op( &self, context: &mut Context, out: &mut String, value: &UnaryOp<&dyn Expression>, )

Render unary operator expression.

fn write_expression_binary_op( &self, context: &mut Context, out: &mut String, value: &BinaryOp<&dyn Expression, &dyn Expression>, )

Render binary operator expression handling precedence / parenthesis.

fn write_expression_ordered( &self, context: &mut Context, out: &mut String, value: &Ordered<&dyn Expression>, )

Render ordered expression inside ORDER BY.

fn write_join_type( &self, _context: &mut Context, out: &mut String, join_type: &JoinType, )

Render join keyword(s) for the given join type.

fn write_join( &self, context: &mut Context, out: &mut String, join: &Join<&dyn DataSet, &dyn DataSet, &dyn Expression>, )

Render a JOIN clause.

fn write_transaction_begin(&self, out: &mut String)

Emit BEGIN statement.

fn write_transaction_commit(&self, out: &mut String)

Emit COMMIT statement.

fn write_transaction_rollback(&self, out: &mut String)

Emit ROLLBACK statement.

fn write_create_schema<E>(&self, out: &mut String, if_not_exists: bool)

where Self: Sized, E: Entity,

Emit CREATE SCHEMA.

fn write_drop_schema<E>(&self, out: &mut String, if_exists: bool)

where Self: Sized, E: Entity,

Emit DROP SCHEMA.

fn write_create_table<E>(&self, out: &mut String, if_not_exists: bool)

where Self: Sized, E: Entity,

Emit CREATE TABLE with columns, constraints & comments.

fn write_create_table_column_fragment( &self, context: &mut Context, out: &mut String, column: &ColumnDef, )

where Self: Sized,

Emit single column definition fragment.

fn write_create_table_primary_key_fragment<'a, It>( &self, context: &mut Context, out: &mut String, primary_key: It, )

where Self: Sized, It: IntoIterator<Item = &'a ColumnDef>, It::IntoIter: Clone,

fn write_create_table_references_action( &self, _context: &mut Context, out: &mut String, action: &Action, )

Emit referential action keyword.

fn write_column_comment_inline( &self, _context: &mut Context, _out: &mut String, _column: &ColumnDef, )

where Self: Sized,

fn write_column_comments_statements<E>( &self, context: &mut Context, out: &mut String, )

where Self: Sized, E: Entity,

Emit COMMENT ON COLUMN statements for columns carrying comments.

fn write_drop_table<E>(&self, out: &mut String, if_exists: bool)

where Self: Sized, E: Entity,

Emit DROP TABLE statement.

fn write_select<Item, Cols, Data, Expr>( &self, out: &mut String, columns: Cols, from: &Data, condition: Expr, limit: Option<u32>, )

where Self: Sized, Item: Expression, Cols: IntoIterator<Item = Item> + Clone, Data: DataSet, Expr: Expression,

Emit SELECT statement (projection, FROM, WHERE, ORDER, LIMIT).

fn write_insert<'b, E>( &self, out: &mut String, entities: impl IntoIterator<Item = &'b E>, update: bool, )

where Self: Sized, E: Entity + 'b,

Emit INSERT (single/multi-row) optionally with ON CONFLICT DO UPDATE.

fn write_insert_update_fragment<'a, E>( &self, context: &mut Context, out: &mut String, columns: impl Iterator<Item = &'a ColumnDef>, )

where Self: Sized, E: Entity,

Emit ON CONFLICT DO UPDATE fragment for upsert.

fn write_delete<E>(&self, out: &mut String, condition: &impl Expression)

where Self: Sized, E: Entity,

Emit DELETE statement with WHERE clause.