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

//! Compare two SQL queries and show semantic differences.
//!
//! Run with: `cargo run --example diff`

use sqlglot_rust::diff::{diff_sql, ChangeAction};
use sqlglot_rust::Dialect;

fn main() {
    let original = "SELECT a, b FROM t WHERE a > 1 ORDER BY a";
    let modified = "SELECT a, c, d FROM t WHERE a > 5 ORDER BY a DESC";

    println!("Original: {original}");
    println!("Modified: {modified}\n");

    let changes = diff_sql(original, modified, Dialect::Ansi).unwrap();

    println!("=== Changes ({} total) ===", changes.len());
    for change in &changes {
        match change {
            ChangeAction::Remove(node) => println!("  - REMOVE: {node:?}"),
            ChangeAction::Insert(node) => println!("  + INSERT: {node:?}"),
            ChangeAction::Keep(node, _) => println!("    KEEP:   {node:?}"),
            ChangeAction::Move(node, _) => println!("  ~ MOVE:   {node:?}"),
            ChangeAction::Update(old, new) => {
                println!("  * UPDATE: {old:?}");
                println!("         → {new:?}");
            }
        }
    }
}