sqlglot-rust 0.9.27

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
30
31
32
33
34

//! Parse and preserve SQL comments through transpilation.
//!
//! Run with: `cargo run --example comments`

use sqlglot_rust::{
    generate, parse_with_comments, transpile_with_comments, Dialect, Statement,
};

fn main() {
    // Parse with comments preserved
    let sql = "-- fetch active users\n/* priority: high */\nSELECT id, name FROM users WHERE active = TRUE";
    println!("=== Input ===");
    println!("{sql}\n");

    let stmt = parse_with_comments(sql, Dialect::Ansi).unwrap();
    if let Statement::Select(ref s) = stmt {
        println!("=== Attached comments ===");
        for c in &s.comments {
            println!("  {c}");
        }
    }

    // Roundtrip: comments survive generate
    println!("\n=== Generated output ===");
    println!("{}\n", generate(&stmt, Dialect::Ansi));

    // Transpile with comments: MySQL → PostgreSQL
    let mysql_sql = "# get user count\nSELECT IFNULL(name, 'unknown') FROM users";
    println!("=== MySQL → PostgreSQL (with comments) ===");
    println!("IN:  {mysql_sql}");
    let result = transpile_with_comments(mysql_sql, Dialect::Mysql, Dialect::Postgres).unwrap();
    println!("OUT: {result}");
    println!("(# comment converted to -- for PostgreSQL)");
}