The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

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

SYNOPSIS

use SQL::Concrete::Dollars ':all';

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.