Rust demo - SQL rewriter powered by the crate sqlparser

Cargo.toml

[package]
name = "rust-sqlparser-demo"
version = "0.1.0"
edition = "2021"

[dependencies]
sqlparser = "0.40"

main.rs

use sqlparser::ast::{Expr, Value};
use sqlparser::dialect::GenericDialect;
use sqlparser::parser::Parser;

fn main() {
    let sql = r#"INSERT INTO "test" (`id`, "sort", name, 'ass') VALUES (?, ?, ?, ?)"#;

    let dialect = GenericDialect {};
    let mut ast = Parser::parse_sql(&dialect, sql).unwrap();
    match &mut ast[0] {
        sqlparser::ast::Statement::Insert {
            columns, source, ..
        } => {
            for item in columns.iter_mut() {
                item.quote_style = Some('"');
            }

            if let Some(obj) = source {
                match &mut *obj.body {
                    sqlparser::ast::SetExpr::Values(obj) => {
                        for mut item in obj.rows[0].iter_mut() {
                            match &mut item {
                                Expr::Value(value) => {
                                    *value = Value::SingleQuotedString("233".to_string());
                                }
                                _ => todo!(),
                            }
                        }
                    }
                    _ => todo!(),
                }
            }
        }
        _ => todo!(),
    }

    let statement = &ast[0];
    let sql = statement.to_string();

    println!("SQL: {}", sql);
}