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

Parse::SQL - simple SQL parser

VERSION

version 0.002

SYNOPSIS

 use strict;
 use warnings;
 use Parse::SQL;
 use Data::Dumper;
 my $parser = Parse::SQL->new;
 print Dumper($parser->from_string('select id from tbl x inner join tbl y on x.idx = y.idx where x.idx < 14'));

DESCRIPTION

Warning: This is a preview release, and the entire API is subject to change several times over the next few releases.

Please check the "SEE ALSO" section before reading any further!

METHODS

parse

Main parsing method.

parse_select

Specific handling for select queries.

token_lvalue

Parse an 'lvalue'.

token_rvalue

Parse an 'rvalue'.

token_operator

Parse binary operators.

check_keyword

Match a keyword.

token_alias

parse_join

parse_statement

token_keyword

parse_from

parse_table_or_query

parse_where

parse_fields

where_am_i

Debug function reporting on the current position in the parsed string.

SEE ALSO

AUTHOR

Tom Molesworth <cpan@entitymodel.com>

LICENSE

Copyright Tom Molesworth 2011. Licensed under the same terms as Perl itself.