Query builders for Atlas.Pdo connections.
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
docs
src add quoteIdentifier() and INSERT/UPDATE quoting Aug 11, 2018
tests add tests for quoters Aug 11, 2018
.gitignore initial commit Mar 12, 2018
CHANGELOG.md
CONTRIBUTING.md update meta docs Apr 7, 2018
LICENSE.md update meta docs Apr 7, 2018
README.md
composer.json
phpunit.php initial commit Mar 12, 2018
phpunit.xml.dist add quoteIdentifier() and INSERT/UPDATE quoting Aug 11, 2018

README.md

Atlas.Query

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

Read the documentation here.

Lineage

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.