pub fn to_sql(
criteria: &Criteria,
dialect: Dialect,
) -> Result<SqlQuery, SqlError>Expand description
Translates criteria to a SQL expression for a WHERE or a SELECT list.
use ravenrs_criteria::{Criteria, Dialect, SqlParam, Value, to_sql};
let c = Criteria::parse("[Total] > 100 And [Name] Like ?Pattern").expect("valid");
let q = to_sql(&c, Dialect::Postgres).expect("translatable");
assert_eq!(q.text, r#""Total" > $1 AND "Name" LIKE $2"#);
assert_eq!(q.params, [SqlParam::Value(Value::Number(100.0)), SqlParam::Named("Pattern".into())]);