teaql-sql 0.9.6

TeaQL core, SQL, runtime, dialect, and macro crates for model-driven data access
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

# teaql-sql

SQL compiler support for TeaQL Rust.

`teaql-sql` turns TeaQL query and mutation models from `teaql-core` into
parameterized SQL plus bind values. Dialect-specific syntax is supplied by a
`SqlDialect` implementation, such as PostgreSQL or SQLite.

## What It Provides

- `SqlDialect` trait
- compiled query and mutation structures
- select SQL compilation
- insert, update, delete, and recover SQL compilation
- DDL helpers for schema creation and missing-column migration
- debug SQL rendering with inlined values for diagnostics

## Example

```rust
use teaql_core::{Expr, SelectQuery, EntityDescriptor, PropertyDescriptor, DataType};
use teaql_sql::{CompiledQuery, SqlCompileError, SqlDialect};

fn compile_for<D: SqlDialect>(dialect: &D) -> Result<CompiledQuery, SqlCompileError> {
    let entity = EntityDescriptor::new("Merchant")
        .table_name("merchant")
        .property(PropertyDescriptor::new("name", DataType::Text).column_name("name"));

    let query = SelectQuery::new("Merchant")
        .filter(Expr::eq("name", "TeaQL"))
        .page(1, 20);

    dialect.compile_select(&entity, &query)
}
```

Most applications should use `teaql-runtime`; use `teaql-sql` directly when
building a custom executor, dialect, or SQL inspection tool.