dsl-parse 3.0.1

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

#[test]
fn parses_basic_select() {
  let p = parse("SELECT id FROM users", Dialect::Postgres);
  assert!(p.errors.is_empty());
  assert_eq!(p.statements.len(), 1);
  let StatementKind::Select(s) = &p.statements[0].kind else {
    panic!("expected Select");
  };
  assert_eq!(s.from.len(), 1);
  assert_eq!(s.from[0].name, "users");
}

#[test]
fn captures_alias() {
  let p = parse("SELECT u.id FROM users u", Dialect::Postgres);
  let StatementKind::Select(s) = &p.statements[0].kind else { panic!() };
  assert_eq!(s.from[0].alias.as_deref(), Some("u"));
}

#[test]
fn captures_join() {
  let p = parse("SELECT * FROM users u JOIN orders o ON o.user_id = u.id", Dialect::Postgres);
  let StatementKind::Select(s) = &p.statements[0].kind else { panic!() };
  assert_eq!(s.joins.len(), 1);
  assert_eq!(s.joins[0].table.name, "orders");
}

#[test]
fn surfaces_per_statement_errors() {
  let p = parse("SELEKT 1; SELECT 2;", Dialect::Postgres);
  assert_eq!(p.errors.len(), 1);
  assert_eq!(p.statements.len(), 2);
}

#[test]
fn captures_schema_qualified_table() {
  let p = parse("SELECT * FROM public.users", Dialect::Postgres);
  let StatementKind::Select(s) = &p.statements[0].kind else { panic!() };
  assert_eq!(s.from[0].schema.as_deref(), Some("public"));
  assert_eq!(s.from[0].name, "users");
}