1.4.7. Other Topics

1.4.7.1. Microsoft SQL Server LIMIT and OFFSET

If the Atlas.Pdo Connection is to a Microsoft SQL Server ('sqlsrv') instance,
the LIMIT-related methods on the query object will generate sqlsrv-specific
variations of LIMIT ... OFFSET:

If only a LIMIT is present, it will be translated as a TOP clause.

If both LIMIT and OFFSET are present, it will be translated as an
OFFSET ... ROWS FETCH NEXT ... ROWS ONLY clause. In this case there must
be an ORDER BY clause, as the offset clause is a sub-clause of ORDER BY.

1.4.7.2. Identifier Quoting

You can apply identifier quoting as needed by using the quoteIdentifier()
method (available on all query objects).

INSERT and UPDATE queries will automatically quote the column name that is being
inserted or updated. No other automatic quoting of identifiers is applied.

1.4.7.3. Table Prefixes

One frequently-requested feature for this package is support for "automatic
table prefixes" on all queries. This feature sounds great in theory, but in
practice it is (1) difficult to implement well, and (2) even when implemented it
turns out to be not as great as it seems in theory. This assessment is the
result of the hard trials of experience. For those of you who want modifiable
table prefixes, we suggest using constants with your table names prefixed as
desired; as the prefixes change, you can then change your constants.