README

Data-driven SQL DSL for Phel Lang. Map in, [sql params] out. No database driver: the only job here is turning data into a parameterised query string.

Inspired by HoneySQL.

(sql/format
  {:select [:id :name]
   :from   [:users]
   :where  [:= :status "active"]})
;; => ["SELECT id, name FROM users WHERE status = ?" ["active"]]

Install

composer require phel-lang/phel-sql

Requires PHP 8.4+ and phel-lang/phel-lang 0.37+.

Use it

(ns my-app.queries
  (:require phel.sql :as sql))

(sql/format
  {:with     [[:active {:select [:id] :from [:users] :where [:= :status "active"]}]]
   :select   [:u/id
              [[:over [:fn :row_number]
                {:partition-by [:u/dept]
                 :order-by [[:u/salary :desc]]}]
               :rk]
              [[:case [:> :u/salary 100000] "high" :else "low"] :tier]]
   :from     [[:users :u]]
   :join     [[:active :a] [:using :id]]
   :where    [:>= :u/age 18]
   :order-by [[:u/dept :asc :nulls-last]]
   :limit    10})

Pass the tuple to any PDO-like driver:

$pdo->prepare($sql)->execute($params);

What it covers

WHERE operators: =, !=, <, >, <=, >=, like, not-like, ilike, not-ilike, and, or, not, in, not-in, between, not-between, is-null, is-not-null, exists, not-exists.

Tagged expression forms usable anywhere an identifier or operand is accepted:

Subqueries (maps) work anywhere an identifier or value is accepted. [:raw "SQL"] is the escape hatch for fragments the DSL does not yet cover.

Docs

• Quickstart: three queries, end to end.
• Clauses: every clause and operator.
• Expressions: function calls, CAST, CASE, window, FILTER, LATERAL.
• Parameters: keywords vs values, subqueries, raw fragments.
• Contributing: repo layout, tests, adding a clause.