TSQL::AST - 'Abstract Syntax Tree' for TSQL.
Parses Microsoft's Transact SQL dialect of SQL.
This only provides a very broad brush parse of TSQL. It aims to be accurate in what it does parse, but not to provide any great detail. Currently it recursively recognises the major block structure elements of TSQL.
This is still *ALPHA* quality software. It should still be a developer-only release, but I'm getting tired of those. If you've come looking for a full-blown TSQL parser, you're going to leave here very disappointed. Even when finished, this is going to leave most of your SQL unparsed. It's simply intended to support another piece of work, which is currently only in the planning stage.
Note TSQL::AST is only intended to parse syntactically valid TSQL. With invalid TSQL, all bets are off.
TSQL::AST depends on the following modules:
<dedmedved at cpan.org>
Please report any bugs or feature requests to
bug-tsql-ast at rt.cpan.org,
or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=TSQL::AST.
I will be notified,
and then you'll automatically be notified of progress on your bug as I make changes.
It creates and returns a new TSQL::AST object.
$ast->parse( array of sqlfragments )
This is the method which parses the split up SQL code from the original script.
my $sql_splitter = TSQL::SplitStatement->new(); my @statements = $sql_splitter->splitSQL( 'SELECT 1;SELECT 2;' ); my $sql_parser = TSQL::AST->new(); my $ast = $sql_parser->parse( \@statements );
This is the method which retrieves the AST for the script just parsed.
my $sql_splitter = TSQL::SplitStatement->new(); my @statements = $sql_splitter->splitSQL( 'SELECT 1;SELECT 2;' ); my $sql_parser = TSQL::AST->new(); my $ast = $sql_parser->parse( \@statements ); my $script = $$ast->script();
No limitations are currently known, as far as the intended usage is concerned. You *are* bound to uncover a large number of problems.
Please report any problematic cases.
You can find documentation for this module with the perldoc command.
You can also look for information at:
Copyright 2012 Ded MedVed.
This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License.
See http://dev.perl.org/licenses/ for more information.