Trait SqlWriter 

pub trait SqlWriter: Send {
    // Required method
    fn as_dyn(&self) -> &dyn SqlWriter;

    // Provided methods
    fn separator(&self) -> &str { ... }
    fn is_alias_declaration(&self, context: &mut Context) -> bool { ... }
    fn write_identifier(
        &self,
        _context: &mut Context,
        out: &mut DynQuery,
        value: &str,
        quoted: bool,
    ) { ... }
    fn write_table_ref(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &TableRef,
    ) { ... }
    fn write_column_ref(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &ColumnRef,
    ) { ... }
    fn write_column_overridden_type(
        &self,
        _context: &mut Context,
        out: &mut DynQuery,
        _column: &ColumnDef,
        types: &BTreeMap<&'static str, &'static str>,
    ) { ... }
    fn write_column_type(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Value,
    ) { ... }
    fn write_value(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Value,
    ) { ... }
    fn write_null(&self, context: &mut Context, out: &mut DynQuery) { ... }
    fn write_bool(&self, context: &mut Context, out: &mut DynQuery, value: bool) { ... }
    fn write_value_i8(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: i8,
    ) { ... }
    fn write_value_i16(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: i16,
    ) { ... }
    fn write_value_i32(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: i32,
    ) { ... }
    fn write_value_i64(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: i64,
    ) { ... }
    fn write_value_i128(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: i128,
    ) { ... }
    fn write_value_u8(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: u8,
    ) { ... }
    fn write_value_u16(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: u16,
    ) { ... }
    fn write_value_u32(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: u32,
    ) { ... }
    fn write_value_u64(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: u64,
    ) { ... }
    fn write_value_u128(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: u128,
    ) { ... }
    fn write_value_f32(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: f32,
    ) { ... }
    fn write_value_f64(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: f64,
    ) { ... }
    fn write_string(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &str,
    ) { ... }
    fn write_blob(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &[u8],
    ) { ... }
    fn write_date(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Date,
    ) { ... }
    fn write_time(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Time,
    ) { ... }
    fn write_timestamp(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &PrimitiveDateTime,
    ) { ... }
    fn write_timestamptz(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &OffsetDateTime,
    ) { ... }
    fn value_interval_units(&self) -> &[(&str, i128)] { ... }
    fn write_interval(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Interval,
    ) { ... }
    fn write_uuid(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Uuid,
    ) { ... }
    fn write_list(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &mut dyn Iterator<Item = &dyn Expression>,
        _ty: Option<&Value>,
        _is_array: bool,
    ) { ... }
    fn write_tuple(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &mut dyn Iterator<Item = &dyn Expression>,
    ) { ... }
    fn write_map(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &HashMap<Value, Value>,
    ) { ... }
    fn write_json(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Value,
    ) { ... }
    fn write_struct(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Vec<(String, Value)>,
    ) { ... }
    fn write_function(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        function: &str,
        args: &[&dyn Expression],
    ) { ... }
    fn expression_unary_op_precedence(&self, value: &UnaryOpType) -> i32 { ... }
    fn expression_binary_op_precedence(&self, value: &BinaryOpType) -> i32 { ... }
    fn write_operand(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Operand<'_>,
    ) { ... }
    fn write_question_mark(&self, context: &mut Context, out: &mut DynQuery) { ... }
    fn write_current_timestamp_ms(
        &self,
        _context: &mut Context,
        out: &mut DynQuery,
    ) { ... }
    fn write_unary_op(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &UnaryOp<&dyn Expression>,
    ) { ... }
    fn write_binary_op(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &BinaryOp<&dyn Expression, &dyn Expression>,
    ) { ... }
    fn write_cast(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        expr: &dyn Expression,
        ty: &dyn Expression,
    ) { ... }
    fn write_ordered(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        value: &Ordered<&dyn Expression>,
    ) { ... }
    fn write_join_type(
        &self,
        _context: &mut Context,
        out: &mut DynQuery,
        join_type: &JoinType,
    ) { ... }
    fn write_join(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        join: &Join<&dyn Dataset, &dyn Dataset, &dyn Expression>,
    ) { ... }
    fn write_transaction_begin(&self, out: &mut DynQuery) { ... }
    fn write_transaction_commit(&self, out: &mut DynQuery) { ... }
    fn write_transaction_rollback(&self, out: &mut DynQuery) { ... }
    fn write_create_schema<E>(&self, out: &mut DynQuery, if_not_exists: bool)
       where Self: Sized,
             E: Entity { ... }
    fn write_drop_schema<E>(&self, out: &mut DynQuery, if_exists: bool)
       where Self: Sized,
             E: Entity { ... }
    fn write_create_table<E>(&self, out: &mut DynQuery, if_not_exists: bool)
       where Self: Sized,
             E: Entity { ... }
    fn write_create_table_column_fragment(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        column: &ColumnDef,
    )
       where Self: Sized { ... }
    fn write_create_table_primary_key_fragment<'a, It>(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        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 DynQuery,
        action: &Action,
    ) { ... }
    fn write_column_comment_inline(
        &self,
        _context: &mut Context,
        _out: &mut DynQuery,
        _column: &ColumnDef,
    )
       where Self: Sized { ... }
    fn write_column_comments_statements<E>(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
    )
       where Self: Sized,
             E: Entity { ... }
    fn write_drop_table<E>(&self, out: &mut DynQuery, if_exists: bool)
       where Self: Sized,
             E: Entity { ... }
    fn write_select<'a, Data>(
        &self,
        out: &mut DynQuery,
        query: &impl SelectQuery<Data>,
    )
       where Self: Sized,
             Data: Dataset + 'a { ... }
    fn write_insert<'b, E>(
        &self,
        out: &mut DynQuery,
        entities: impl IntoIterator<Item = &'b E>,
        update: bool,
    )
       where Self: Sized,
             E: Entity + 'b { ... }
    fn write_insert_update_fragment<'a, E>(
        &self,
        context: &mut Context,
        out: &mut DynQuery,
        columns: impl Iterator<Item = &'a ColumnDef> + Clone,
    )
       where Self: Sized,
             E: Entity { ... }
    fn write_delete<E>(&self, out: &mut DynQuery, condition: impl Expression)
       where Self: Sized,
             E: Entity { ... }
}

SQL dialect printer.

Required Methods

fn as_dyn(&self) -> &dyn SqlWriter

Upcasts self to a distinct dynamic object.

Provided Methods

fn separator(&self) -> &str

Separator used for qualified names (e.g., schema.table.column)

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

Determines if the current SQL context supports alias declarations.

fn write_identifier( &self, _context: &mut Context, out: &mut DynQuery, value: &str, quoted: bool, )

Writes an identifier (like a table or column name) to the query builder, optionally quoting it.

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

Write table reference.

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

Write column reference.

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

Write overridden type.

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

Write SQL type name.

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

Write value.

fn write_null(&self, context: &mut Context, out: &mut DynQuery)

fn write_bool(&self, context: &mut Context, out: &mut DynQuery, value: bool)

fn write_value_i8(&self, context: &mut Context, out: &mut DynQuery, value: i8)

fn write_value_i16(&self, context: &mut Context, out: &mut DynQuery, value: i16)

fn write_value_i32(&self, context: &mut Context, out: &mut DynQuery, value: i32)

fn write_value_i64(&self, context: &mut Context, out: &mut DynQuery, value: i64)

fn write_value_i128( &self, context: &mut Context, out: &mut DynQuery, value: i128, )

fn write_value_u8(&self, context: &mut Context, out: &mut DynQuery, value: u8)

fn write_value_u16(&self, context: &mut Context, out: &mut DynQuery, value: u16)

fn write_value_u32(&self, context: &mut Context, out: &mut DynQuery, value: u32)

fn write_value_u64(&self, context: &mut Context, out: &mut DynQuery, value: u64)

fn write_value_u128( &self, context: &mut Context, out: &mut DynQuery, value: u128, )

fn write_value_f32(&self, context: &mut Context, out: &mut DynQuery, value: f32)

fn write_value_f64(&self, context: &mut Context, out: &mut DynQuery, value: f64)

fn write_string(&self, context: &mut Context, out: &mut DynQuery, value: &str)

fn write_blob(&self, context: &mut Context, out: &mut DynQuery, value: &[u8])

fn write_date(&self, context: &mut Context, out: &mut DynQuery, value: &Date)

fn write_time(&self, context: &mut Context, out: &mut DynQuery, value: &Time)

fn write_timestamp( &self, context: &mut Context, out: &mut DynQuery, value: &PrimitiveDateTime, )

fn write_timestamptz( &self, context: &mut Context, out: &mut DynQuery, value: &OffsetDateTime, )

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

Units used to decompose intervals (notice the decreasing order).

fn write_interval( &self, context: &mut Context, out: &mut DynQuery, value: &Interval, )

fn write_uuid(&self, context: &mut Context, out: &mut DynQuery, value: &Uuid)

fn write_list( &self, context: &mut Context, out: &mut DynQuery, value: &mut dyn Iterator<Item = &dyn Expression>, _ty: Option<&Value>, _is_array: bool, )

fn write_tuple( &self, context: &mut Context, out: &mut DynQuery, value: &mut dyn Iterator<Item = &dyn Expression>, )

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

fn write_json(&self, context: &mut Context, out: &mut DynQuery, value: &Value)

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

fn write_function( &self, context: &mut Context, out: &mut DynQuery, function: &str, args: &[&dyn Expression], )

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_operand( &self, context: &mut Context, out: &mut DynQuery, value: &Operand<'_>, )

fn write_question_mark(&self, context: &mut Context, out: &mut DynQuery)

fn write_current_timestamp_ms(&self, _context: &mut Context, out: &mut DynQuery)

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

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

Render binary operator expression handling precedence and parenthesis.

fn write_cast( &self, context: &mut Context, out: &mut DynQuery, expr: &dyn Expression, ty: &dyn Expression, )

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

Render ordered expression inside ORDER BY.

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

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

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

Render a JOIN clause.

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

Emit BEGIN statement.

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

Emit COMMIT statement.

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

Emit ROLLBACK statement.

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

where Self: Sized, E: Entity,

Emit CREATE SCHEMA.

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

where Self: Sized, E: Entity,

Emit DROP SCHEMA.

fn write_create_table<E>(&self, out: &mut DynQuery, 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 DynQuery, 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 DynQuery, primary_key: It, )

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

Write PRIMARY KEY constraint.

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

Write referential action.

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

where Self: Sized,

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

where Self: Sized, E: Entity,

Write column comments.

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

where Self: Sized, E: Entity,

Write DROP TABLE statement.

fn write_select<'a, Data>( &self, out: &mut DynQuery, query: &impl SelectQuery<Data>, )

where Self: Sized, Data: Dataset + 'a,

Write SELECT statement.

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

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

Write INSERT statement.

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

where Self: Sized, E: Entity,

Write ON CONFLICT DO UPDATE fragment for upsert.

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

where Self: Sized, E: Entity,

Write DELETE statement.

Implementors

impl SqlWriter for GenericSqlWriter