#!/usr/bin/env perl use SQL::Abstract::Tree; use Getopt::Long::Descriptive; my ($opt, $usage) = describe_options( 'format-sql %o', [ 'profile|p=s', "the profile to use", { default => 'console' } ], [ 'help', "print usage message and exit" ], ); print($usage->text), exit if $opt->help; my $sqlat = SQL::Abstract::Tree->new({ profile => $opt->profile, fill_in_placeholders => 0 }); print $sqlat->format($_) . "\n" while <>;