SQL::Formatter

Format SQL using the rust sqlformat library

SYNOPSIS

my $f = SQL::Formatter->new;
say $f->format('select foo.a, foo.b, bar.c from foo join bar on foo.a = bar.c where foo.b = 2');

prints:

SELECT
  foo.a,
  foo.b,
  bar.c
FROM
  foo
  JOIN bar ON foo.a = bar.c
WHERE
  foo.b = 2

Pretty print SQL using the rust crate sqlformat.

The formatting options can be specified either when the object is constructed, or later using accessors.

my $f = SQL::Format->new( indent => 4 );
$f->indent(4);

indent

Controls the length of indentation to use. The default is 2.
uppercase

When set to true (the default), changes reserved keywords to ALL CAPS.
lines_between_queries

Controls the number of line breaks after a query. The default is 1.

my $pretty_sql = $f->format($sql);

Formats whitespace in a SQL string to make it easier to read.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.