dsl-parse 0.1.0

Facade over sqlparser / pg_query producing a unified SQL Statement representation for duck-sqllsp.
Documentation
use dsl_parse::{Dialect, StatementKind, parse};

#[test]
fn parses_insert() {
  let p = parse("INSERT INTO users (name, email) VALUES ('alice', 'a@x');", Dialect::Postgres);
  let StatementKind::Insert(i) = &p.statements[0].kind else { panic!() };
  assert_eq!(i.table.name, "users");
  assert_eq!(i.columns, vec!["name", "email"]);
}

#[test]
fn parses_update_with_where() {
  let p = parse("UPDATE users SET active = false WHERE id = 1;", Dialect::Postgres);
  let StatementKind::Update(u) = &p.statements[0].kind else { panic!() };
  assert_eq!(u.table.name, "users");
  assert_eq!(u.assignments.len(), 1);
  assert!(u.where_clause.is_some());
}

#[test]
fn parses_delete_with_where() {
  let p = parse("DELETE FROM sessions WHERE expires_at < now();", Dialect::Postgres);
  let StatementKind::Delete(d) = &p.statements[0].kind else { panic!() };
  assert_eq!(d.table.name, "sessions");
  assert!(d.where_clause.is_some());
}