Reference
Database Dialects
Quarry keeps placeholder rendering, quoting, and feature support on the configured dialect so output stays predictable.
Placeholder matrix
| Dialect | Placeholder style | Notes |
|---|---|---|
| Postgres | $1, $2, ... |
Supports positional numbering and nested subquery offsetting. |
| MySQL | ? |
Uses question marks for values and backticks for identifiers. |
| SQLite | ? |
Uses question marks for values and double quotes for identifiers. |
Feature policy
RETURNING
Supported by Postgres and SQLite. MySQL returns a clear unsupported-feature error.
ILIKE
Native on Postgres, with a LOWER/LIKE fallback on MySQL and SQLite.
ANY
Postgres only. Other dialects return a wrapped unsupported-feature error.
Quoting
Use the identifier helpers page when you want Quarry to quote and validate names instead of treating them as raw SQL.
users := quarry.T("users").As("u")
q := qq.Select(users.Col("id"), users.Col("email")).From(users)