🌻 📖 SQL::Formatter

NAME

SQL::Formatter - Format SQL using the rust sqlformat library

VERSION

version 0.01

 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.

Graham Ollis <plicease@cpan.org>

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