NAME

DBIx::Class::SQLAHacks - This module is a subclass of SQL::Abstract::Limit and includes a number of DBIC-specific workarounds, not yet suitable for inclusion into SQLA proper.

METHODS

new

Tries to determine limit dialect.

select

Quotes table names, handles "limit" dialects (e.g. where rownum between x and y), supports SELECT ... FOR UPDATE and SELECT ... FOR SHARE.

insert update delete

Just quotes table names.

limit_dialect

Specifies the dialect of used for implementing an SQL "limit" clause for restricting the number of query results returned. Valid values are: RowNum.

See connect_info in the DBIx::Class::Storage::DBI manpage for details.

name_sep

Character separating quoted table names.

See connect_info in the DBIx::Class::Storage::DBI manpage for details.

quote_char

Set to an array-ref to specify separate left and right quotes for table names.

See connect_info in the DBIx::Class::Storage::DBI manpage for details.