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

//! Transpile SQL between dialects.
//!
//! Run with: `cargo run --example transpile`

use sqlglot_rust::{transpile, Dialect};

fn main() {
    let examples = [
        // Function mapping
        ("SELECT NOW()", Dialect::Postgres, Dialect::Tsql, "NOW → GETDATE"),
        ("SELECT IFNULL(a, b) FROM t", Dialect::Mysql, Dialect::Postgres, "IFNULL → COALESCE"),
        // LIMIT → TOP
        ("SELECT * FROM t LIMIT 5", Dialect::Mysql, Dialect::Tsql, "LIMIT → TOP"),
        // Identifier quoting
        ("SELECT \"user\" FROM t", Dialect::Postgres, Dialect::Mysql, "Double-quote → backtick"),
        // ILIKE rewriting
        ("SELECT * FROM t WHERE name ILIKE '%test%'", Dialect::Postgres, Dialect::Mysql, "ILIKE → LOWER/LIKE"),
        // Data types
        ("CREATE TABLE t (id SERIAL)", Dialect::Postgres, Dialect::Mysql, "SERIAL → INT AUTO_INCREMENT"),
    ];

    for (sql, from, to, label) in examples {
        let result = transpile(sql, from, to).unwrap();
        println!("[{label}]");
        println!("  {from:?} → {to:?}");
        println!("  IN:  {sql}");
        println!("  OUT: {result}\n");
    }
}