The Perl and Raku Conference 2025: Greenville, South Carolina - June 27-29 Learn more

NAME

SQL::Concrete::Dollars - use SQL::Concrete with dollar placeholders

SYNOPSIS

DESCRIPTION

This module is just like SQL::Concrete, except that automatically generated placeholders will use numbered placeholder syntax instead of the more common question mark syntax (i.e. $, $2, $3 instead of ?, ?, ?).

If for some reason you wish to use both forms and want to be able to choose on a per-query basis, you can export sql_render from this module with a prefix:

use SQL::Concrete ':all';
use SQL::Concrete::Dollars _prefix => 'pg', ':core';
# you can now use either sql_render or pgsql_render
# depending on the form of placeholders you want

For all further details, please refer to the SQL::Concrete documentation.