sqlglot-rust 0.9.25

A SQL parser, optimizer, and transpiler library inspired by Python's sqlglot
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

//! Parse SQL into an AST and generate it back.
//!
//! Run with: `cargo run --example parse_and_generate`

use sqlglot_rust::{generate, generate_pretty, parse, Dialect, Statement};

fn main() {
    let sql = "SELECT id, name, salary * 1.1 AS adjusted FROM employees WHERE department = 'Engineering' ORDER BY salary DESC LIMIT 10";

    // Parse into AST
    let ast = parse(sql, Dialect::Ansi).unwrap();

    // Compact output
    println!("=== Compact ===");
    println!("{}\n", generate(&ast, Dialect::Ansi));

    // Pretty-printed output
    println!("=== Pretty ===");
    println!("{}\n", generate_pretty(&ast, Dialect::Ansi));

    // Inspect the AST
    println!("=== AST Debug ===");
    if let Statement::Select(ref s) = ast {
        println!("Columns: {}", s.columns.len());
        println!("Has WHERE: {}", s.where_clause.is_some());
        println!("ORDER BY items: {}", s.order_by.len());
        println!("LIMIT: {:?}", s.limit);
    }
}