/ 
DBIO-Firebird-0.900000
/ DBIO::Firebird::SQLMaker

NAME

DBIO::Firebird::SQLMaker - Firebird-specific SQL generation for DBIO

VERSION

version 0.900000

DESCRIPTION

DBIO::SQLMaker subclass for the Firebird RDBMS. Firebird has no LIMIT/OFFSET keyword; it slices result sets with FIRST n SKIP m immediately after SELECT. This class implements that via "apply_limit".

Set as the sql_maker_class by DBIO::Firebird::Storage::Common, so both the DBD::Firebird and DBD::InterBase variants use it. Not normally instantiated directly.

METHODS

apply_limit

my $sql = $sqlmaker->apply_limit($sql, $rs_attrs, $rows, $offset);

Emits SELECT FIRST ? SKIP ? ... instead of the default ... LIMIT ? OFFSET ?, which Firebird does not understand. Replaces the DBIx::Class sql_limit_dialect = 'FirstSkip' string dispatch.

SEE ALSO

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.