Expand description
Dialect-agnostic SQL primitives shared by the Postgres (cratestack-sqlx)
and SQLite (cratestack-rusqlite) backends.
This crate carries the type definitions every backend agrees on:
SqlValue/SqlColumnValue— value envelopes used to bind dataCreateModelInput/UpdateModelInput/UpsertModelInput— traits the codegen emitsFilter/FilterExpr/FieldRef— query ASTOrderClause/SortDirection— ordering ASTModelDescriptor/ModelColumn/CreateDefault— schema metadata baked into compiled code byinclude_schema!
Rendering SQL strings, executing queries, and any DB-driver coupling live in the backend crates.
Structs§
- Create
Default - Field
Ref - Filter
- Model
Column - Model
Descriptor - Order
Clause - Postgres
Dialect - Postgres dialect —
$Nplaceholders. - Relation
Filter - SqlColumn
Value - Sqlite
Dialect - SQLite dialect —
?Nplaceholders.
Enums§
Traits§
- Create
Model Input - Dialect
- Backend SQL dialect.
- Into
SqlValue - Model
Primary Key - Accessor for a model’s primary key. Implemented by the macro on every
generated model struct so the batch operations can pair returned rows
back to the position of their input PK in the request, producing a
BatchItemResultwith the rightindexand aNotFoundentry for any requested PK that didn’t come back. - Update
Model Input - Upsert
Model Input - Input shape for the upsert primitive —
INSERT … ON CONFLICT (<pk>) DO UPDATE ….sql_values()must include the primary-key column (so the backend can target the conflict), andprimary_key_value()exposes the PK separately so the runtime can issue aSELECT … FOR UPDATEbefore the upsert to driveCreatedvs.Updatedevent / audit semantics.
Functions§
- find_
duplicate_ sql_ value - Detect the first duplicate value in a list of
SqlValues, used for batch_upsert input deduplication. Linear-scan withPartialEqrather than the hashed variant incratestack-corebecauseSqlValue::FloatandSqlValue::Decimaldon’t admit a soundHashimpl.