qail_core/transpiler/sql/
sqlite.rs

1use super::super::traits::SqlGenerator;
2
3pub struct SqliteGenerator;
4
5impl SqlGenerator for SqliteGenerator {
6    fn quote_identifier(&self, id: &str) -> String {
7        format!("\"{}\"", id)
8    }
9
10    fn placeholder(&self, _index: usize) -> String {
11        "?".to_string()
12    }
13
14    fn fuzzy_operator(&self) -> &str {
15        "LIKE"
16    }
17
18    fn bool_literal(&self, val: bool) -> String {
19        if val {
20            "1".to_string()
21        } else {
22            "0".to_string()
23        }
24    }
25
26    fn string_concat(&self, parts: &[&str]) -> String {
27        parts.join(" || ")
28    }
29
30    fn limit_offset(&self, limit: Option<usize>, offset: Option<usize>) -> String {
31        let mut sql = String::new();
32        if let Some(n) = limit {
33            sql.push_str(&format!(" LIMIT {}", n));
34        }
35        if let Some(n) = offset {
36            sql.push_str(&format!(" OFFSET {}", n));
37        }
38        sql
39    }
40}
qail_core/transpiler/sql/sqlite.rs

qail_core/transpiler/sql/
sqlite.rs
