Help for this page

Select Code to Download

Select or download this

my $sql = { SELECT => [ 'column1', 'column2', 'column3' ],
            FROM   => [ 'table1', 'table2' ],
...
            HAVING => ' AND ',
            GROUP_BY => ',',
            ORDER_BY => ',' };

Select or download this

my $query = join ' ', map { join $sep->{$_}, @{$sql->{$_}} } qw(SELECT
+ FROM WHERE GROUP_BY HAVING);