Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer.

1.3.0 2019-12-13 18:01 UTC

This package is auto-updated.

Last update: 2021-03-29 19:50:43 UTC


Provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server backends connected via Atlas.Pdo.

Read the documentation here.


This package is a descendant of Aura.SqlQuery but differs from that package in significant ways. Some of those differences include:

  • The query objects depend on an Atlas.Pdo Connection (which can wrap a regular PDO instance).

  • There are no database-specific query classes as with the Aura package, though some database-specific behaviors are provided. This means the query object can be more reliably typehinted and provide IDE auto-completion, but at the cost of providing some methods that some databases may not recognize.

  • The Insert class provides only single-row inserts, not multiple-row.

  • Binding of values into Atlas queries allows for different PDO parameter types.

  • Some method names have changed slightly; for example, cols() is now columns(). Likewise, some method signatures have changed; for example, whereas in Aura.SqlQuery a method might take an array of expressions, the equivalent Atlas.Query method may use variadic arguments instead.