nautilus-dialect

SQL dialect renderers for the Nautilus ORM.

This crate translates query ASTs produced by nautilus-core into dialect-specific SQL strings with bound parameters ready for execution via nautilus-connector.

Supported dialects

Usage

use nautilus_dialect::{Dialect, PostgresDialect};
use nautilus_core::{Select, Value};

let select = Select::from_table("users")
    .filter(
        nautilus_core::Expr::column("email")
            .eq(nautilus_core::Expr::param(Value::String("alice@example.com".into())))
    )
    .build()?;

let sql = PostgresDialect.render_select(&select)?;
// sql.text   => SELECT * FROM "users" WHERE ("email" = $1)
// sql.params => [Value::String("alice@example.com")]

Architecture

The crate is organized as follows:

• lib.rs — Public API: Dialect trait, Sql struct, shared rendering macros (render_insert_body!, render_update_body!, render_delete_body!, render_select_body_core!, render_returning!), and shared identifier-quoting helpers (double_quote_identifier, backtick_quote_identifier).

• postgres.rs — PostgreSQL renderer. Handles $N placeholders, DISTINCT ON, FILTER (WHERE ...) on aggregates, and @> / <@ / && array operators.

• mysql.rs — MySQL renderer. Uses ? placeholders and backtick quoting. Emits LIMIT 18446744073709551615 when only OFFSET is requested (MySQL requires LIMIT before OFFSET). RETURNING is silently omitted.

• sqlite.rs — SQLite renderer. Uses ? placeholders and ANSI double-quote quoting. Supports RETURNING (SQLite 3.35+) and native FILTER (WHERE ...) on aggregates.

Array operators

PostgreSQL natively supports @> (contains), <@ (contained by), and && (overlaps) array operators via BinaryOp::ArrayContains, BinaryOp::ArrayContainedBy, and BinaryOp::ArrayOverlaps.

MySQL emulates these via JSON_CONTAINS(target, candidate) for contains / contained-by (swapping argument order) and JSON_OVERLAPS(a, b) for overlap (requires MySQL 8.0.17+). SQLite uses json_each subqueries to check element membership. Arrays are bound as JSON strings by the connector layer, so no special client-side handling is needed.