SQL::Concrete::Dollars - use SQL::Concrete with dollar placeholders
use SQL::Concrete::Dollars ':all';
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 ?, ?, ?).
$, $2, $3
?, ?, ?
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:
sql_render
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.
To install SQL::Concrete, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Concrete
CPAN shell
perl -MCPAN -e shell install SQL::Concrete
For more information on module installation, please visit the detailed CPAN module installation guide.