where-clause

Parses a declarative filter object with $op(value) strings into a typed, database-agnostic filter AST. Zero dependencies, ~50 ns per call.

Content: DQL, Select statement, Where clause, Single and multi-line comment, Operators =,<=,>=,<>, and or operators, between clause, limit clause, orderby clause, Order of execution for the clauses, IN, NOT IN operators.

"SQL Where Clause" Extraction from User Chat Query with LLM

Compile constrained Pydantic models into SQLAlchemy WHERE-rule dictionaries.

CEL → PostgreSQL WHERE clause transpiler for pgx. Fail-closed column allow-list, parameterized $N placeholders.

pgx QueryRewriter that injects hashicorp/mql dynamic filters as safe, parameterised WHERE clauses

pgx QueryRewriter that injects dynamic WHERE and ORDER BY clauses via SQL sentinel comments — safe, parameterised, zero-magic