test_param_repro/
test_param_repro.rs

1use qail_core::{parse, transpiler::ToSqlParameterized};
2
3fn main() {
4    let query = "get::t 'coalesce(uc.unread_count, 0)@unread_count";
5
6    match parse(query) {
7        Ok(cmd) => {
8            let res = cmd.to_sql_parameterized();
9            println!("SQL: {}", res.sql);
10            if res
11                .sql
12                .contains("coalesce(uc.unread_count, 0) AS \"unread_count\"")
13                || res
14                    .sql
15                    .contains("COALESCE(uc.unread_count, 0) AS \"unread_count\"")
16            {
17                println!("SUCCESS: Alias found correctly.");
18            } else {
19                println!("FAILURE: Alias missing in parameterized SQL.");
20                std::process::exit(1);
21            }
22        }
23        Err(e) => {
24            eprintln!("Parse error: {}", e);
25            std::process::exit(1);
26        }
27    }
28}