PHP SQL Parser Class: Parse SQL to extract the SQL query structure

Recommend this page to a friend!

Download

Info

Example

Files

Install with Composer

Download

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 123		All time: 9,468 This week: 41

Version		License		PHP version		Categories
`php-sql-parser` 1.0.0		GNU General Publi...		5		PHP 5, Databases, Parsers

Description

Authors

Justin Swanhart
Andr� Rothe

Contributor

Michael Cummings

This package can parse SQL to extract the SQL query structure.

It can take as parameter a SQL query string and returns the structure of a query split into its parts.

The package returns an associative array with the information of its parts like the query type, options, field names, values, where condition clause, etc..

Michael Cummings

Performance

Level

Name:	Michael Cummings `<contact>`
Classes:	9 packages by Michael Cummings
Country:	United States
Age:	???
All time rank:	1895	263 in United States
Week rank:	49	7 in United States

Level 3

Innovation award

Nominee: 7x

Winner: 1x

Example


<?php



/**

 * you cannot execute this script within Eclipse PHP

 * because of the limited output buffer. Try to run it

 * directly within a shell.

 */



namespace PHPSQLParser;

require_once dirname(__FILE__) . '/../vendor/autoload.php';



$sql = 'SELECT 1';

echo $sql . "\n";

$start = microtime(true);

$parser = new PHPSQLParser($sql, true);

$stop = microtime(true);

print_r($parser->parsed);

echo "parse time simplest query:" . ($stop - $start) . "\n";



/*You can use the constuctor for parsing.  The parsed statement is stored at the ->parsed property.*/

$sql = 'REPLACE INTO table (a,b,c) VALUES (1,2,3)';

echo $sql . "\n";

$start = microtime(true);

$parser = new PHPSQLParser($sql);

$stop = microtime(true);

print_r($parser->parsed);

echo "parse time very somewhat simple statement:" . ($stop - $start) . "\n";



/* You can use the ->parse() method too.  The parsed structure is returned, and 

   also available in the ->parsed property. */

$sql = 'SELECT a,b,c 

          from some_table an_alias

    where d > 5;';

echo $sql . "\n";

print_r($parser->parse($sql, true));



$sql = 'SELECT a,b,c 

          from some_table an_alias

      join `another` as `another table` using(id)

    where d > 5;';

echo $sql . "\n";

$parser = new PHPSQLParser($sql, true);

print_r($parser->parsed);



$sql = 'SELECT a,b,c 

          from some_table an_alias

      join (select d, max(f) max_f

                 from some_table 

                where id = 37

                group by d) `subqry` on subqry.d = an_alias.d

    where d > 5;';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = "(select `c2`, `c```, \"quoted \'string\' \\\" with `embedded`\\\"\\\" quotes\" as `an``alias` from table table)

UNION ALL (select `c2`, `c```, \"quoted \'string\' \\\" with `embedded`\\\"\\\" quotes\" as `an``alias` from table table)";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = "(select `c2`, `c```, \"quoted \'string\' \\\" with `embedded`\\\"\\\" quotes\" as `an``alias` from table table)

UNION  (select `c2`, `c```, \"quoted \'string\' \\\" with `embedded`\\\"\\\" quotes\" as `an``alias` from table table)";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = "select `c2`, `c```, \"quoted \'string\' \\\" with `embedded`\\\"\\\" quotes\" as `an``alias` from table table";

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = "alter table xyz add key my_key(a,b,c), drop primay key";

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'INSERT INTO table (a,b,c) VALUES (1,2,3)

  ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id), c=3;';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'UPDATE t1 SET col1 = col1 + 1, col2 = col1;';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'DELETE FROM t1, t2 USING t1 INNER JOIN t2 INNER JOIN t3

WHERE t1.id=t2.id AND t2.id=t3.id;';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'delete low_priority partitioned_table.* from partitioned_table where partition_id = 1;';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = "UPDATE t1 SET col1 = col1 + 1, col2 = col1;";

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'insert into partitioned_table (partition_id, some_col) values (1,2);';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'delete from partitioned_table where partition_id = 1;';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'SELECT 1';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'SHOW TABLE STATUS';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'SHOW TABLES';

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'select DISTINCT 1+2   c1, 1+ 2 as 

`c2`, sum(c2),"Status" = CASE

        WHEN quantity > 0 THEN \'in stock\'

        ELSE \'out of stock\'

        END 

, t4.c1, (select c1+c2 from t1 inner_t1 limit 1) as subquery into @a1, @a2, @a3 from t1 the_t1 left outer join t2 using(c1,c2) join t3 as tX on tX.c1 = the_t1.c1 natural join t4 t4_x using(cX)  where c1 = 1 and c2 in (1,2,3, "apple") and exists ( select 1 from some_other_table another_table where x > 1) and ("zebra" = "orange" or 1 = 1) group by 1, 2 having sum(c2) > 1 ORDER BY 2, c1 DESC LIMIT 0, 10 into outfile "/xyz" FOR UPDATE LOCK IN SHARE MODE';



echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = "(select 1, 1, 1, 1 from dual dual1) union all (select 2, 2, 2, 2 from dual dual2) union all (select c1,c2,c3,sum(c4) from (select c1,c2,c3,c4 from a_table where c2 = 1) subquery group by 1,2,3) limit 10";

echo $sql . "\n";

$parser = new PHPSQLParser($sql);

print_r($parser->parsed);



$sql = 'select DISTINCT 1+2   c1, 1+ 2 as 

`c2`, sum(c2),"Status" = CASE

        WHEN quantity > 0 THEN "in stock"

        ELSE "out of stock"

        END 

, t4.c1, (select c1+c2 from t1 table limit 1) as subquery into @a1, @a2, @a3 from `table` the_t1 left outer join t2 using(c1,c2) join

(select a, b, length(concat(a,b,c)) from ( select 1 a,2 b,3 c from some_Table ) table ) subquery_in_from join t3 as tX on tX.c1 = the_t1.c1 natural join t4 t4_x using(cX)  where c1 = 1 and c2 in (1,2,3, "apple") and exists ( select 1 from some_other_table another_table where x > 1) and ("zebra" = "orange" or 1 = 1) group by 1, 2 having sum(c2) > 1 ORDER BY 2, c1 DESC LIMIT 0, 10 into outfile "/xyz" FOR UPDATE LOCK IN SHARE MODE

UNION ALL

SELECT NULL,NULL,NULL,NULL,NULL FROM DUAL LIMIT 1';



$start = microtime(true);

$parser = new PHPSQLParser($sql);

$stop = microtime(true);

echo "Parse time highly complex statement: " . ($stop - $start) . "\n";



?>

Details

PHP-SQL-Parser

A pure PHP SQL (non validating) parser w/ focus on MySQL dialect of SQL

Download

GitHub Wiki<br>

Full support for the MySQL dialect for the following statement types

SELECT
INSERT
UPDATE
DELETE
REPLACE
RENAME
SHOW
SET
DROP
CREATE INDEX
CREATE TABLE
EXPLAIN
DESCRIBE

Other SQL statement types

Other statements are returned as an array of tokens. This is not as structured as the information available about the above types. See the ParserManual for more information.

Other SQL dialects

Since the MySQL SQL dialect is very close to SQL-92, this should work for most database applications that need a SQL parser. If using another database dialect, then you may want to change the reserved words - see the ParserManual. It supports UNION, subqueries and compound statements.

External dependencies

The parser is a self contained class. It has no external dependencies. The parser uses a small amount of regex.

Focus

The focus of the parser is complete and accurate support for the MySQL SQL dialect. The focus is not on optimizing for performance. It is expected that you will present syntactically valid queries.

Manual

ParserManual - Check out the manual.

Example Output

Example Query

SELECT STRAIGHT_JOIN a, b, c 
  FROM some_table an_alias
 WHERE d > 5;

Example Output (via print_r)

Array
( 
    [OPTIONS] => Array
        (
            [0] => STRAIGHT_JOIN
        )       
        
    [SELECT] => Array
        (
            [0] => Array
                (
                    [expr_type] => colref
                    [base_expr] => a
                    [sub_tree] => 
                    [alias] => `a`
                )

            [1] => Array
                (
                    [expr_type] => colref
                    [base_expr] => b
                    [sub_tree] => 
                    [alias] => `b`
                )

            [2] => Array
                (
                    [expr_type] => colref
                    [base_expr] => c
                    [sub_tree] => 
                    [alias] => `c`
                )

        )

    [FROM] => Array
        (
            [0] => Array
                (
                    [table] => some_table
                    [alias] => an_alias
                    [join_type] => JOIN
                    [ref_type] => 
                    [ref_clause] => 
                    [base_expr] => 
                    [sub_tree] => 
                )

        )

    [WHERE] => Array
        (
            [0] => Array
                (
                    [expr_type] => colref
                    [base_expr] => d
                    [sub_tree] => 
                )

            [1] => Array
                (
                    [expr_type] => operator
                    [base_expr] => >
                    [sub_tree] => 
                )

            [2] => Array
                (
                    [expr_type] => const
                    [base_expr] => 5
                    [sub_tree] => 
                )

        )

)

Files (575)

File	Role	Description
`.settings` (4 files)
`examples` (2 files)
`libs` (1 directory)
`src` (1 directory)
`tests` (2 files, 2 directories)
`vendor` (1 file)
`wiki` (5 files)
`.buildpath`	Data	Auxiliary data
`.eclipse-PHP-formatter.xml`	Data	Auxiliary data
`.project`	Data	Auxiliary data
`composer.json`	Data	Auxiliary data
`LICENSE`	Lic.	License text
`phpunit.xml.dist`	Data	Auxiliary data
`README.md`	Doc.	Documentation

File	Role	Description
`org.eclipse.ltk.core.refactoring.prefs`	Data	Auxiliary data
`org.eclipse.php.core.prefs`	Data	Auxiliary data
`org.eclipse.php.de...s_Preferences.prefs`	Data	Auxiliary data
`org.eclipse.php.ui.prefs`	Data	Auxiliary data

File	Role	Description
`example.php`	Example	Example script
`OracleSQLTranslator.php`	Class	Class source

File	Role	Description
`PhOSCo` (1 file, 1 directory)
`usage.txt`	Doc.	Documentation

File	Role	Description
`Classes` (1 file)
`Commenting` (2 files)
`ControlStructures` (1 file)
`Functions` (1 file)

File	Role	Description
`ClassCommentSniff.php`	Class	Class source
`FileCommentSniff.php`	Class	Class source

File	Role	Description
`builders` (100 files)
`exceptions` (4 files)
`lexer` (2 files)
`positions` (1 file)
`processors` (44 files)
`utils` (3 files)
`PHPSQLCreator.php`	Class	Class source
`PHPSQLParser.php`	Class	Class source

File	Role	Description
`AliasBuilder.php`	Class	Class source
`AliasReferenceBuilder.php`	Class	Class source
`BracketStatementBuilder.php`	Class	Class source
`Builder.php`	Class	Class source
`CharacterSetBuilder.php`	Class	Class source
`CheckBuilder.php`	Class	Class source
`CollationBuilder.php`	Class	Class source
`ColumnDefinitionBuilder.php`	Class	Class source
`ColumnListBuilder.php`	Class	Class source
`ColumnReferenceBuilder.php`	Class	Class source
`ColumnTypeBracketExpressionBuilder.php`	Class	Class source
`ColumnTypeBuilder.php`	Class	Class source
`ConstantBuilder.php`	Class	Class source
`ConstraintBuilder.php`	Class	Class source
`CreateBuilder.php`	Class	Class source
`CreateIndexBuilder.php`	Class	Class source
`CreateIndexOptionsBuilder.php`	Class	Class source
`CreateIndexTableBuilder.php`	Class	Class source
`CreateIndexTypeBuilder.php`	Class	Class source
`CreateStatementBuilder.php`	Class	Class source
`CreateTableBuilder.php`	Class	Class source
`CreateTableDefinitionBuilder.php`	Class	Class source
`CreateTableOptionsBuilder.php`	Class	Class source
`CreateTableSelectOptionBuilder.php`	Class	Class source
`DatabaseBuilder.php`	Class	Class source
`DataTypeBuilder.php`	Class	Class source
`DefaultValueBuilder.php`	Class	Class source
`DeleteBuilder.php`	Class	Class source
`DeleteStatementBuilder.php`	Class	Class source
`DirectionBuilder.php`	Class	Class source
`DropExpressionBuilder.php`	Class	Class source
`DropStatementBuilder.php`	Class	Class source
`EngineBuilder.php`	Class	Class source
`ForeignKeyBuilder.php`	Class	Class source
`ForeignRefBuilder.php`	Class	Class source
`FromBuilder.php`	Class	Class source
`FunctionBuilder.php`	Class	Class source
`GroupByAliasBuilder.php`	Class	Class source
`GroupByBuilder.php`	Class	Class source
`HavingBracketExpressionBuilder.php`	Class	Class source
`HavingBuilder.php`	Class	Class source
`HavingExpressionBuilder.php`	Class	Class source
`IndexAlgorithmBuilder.php`	Class	Class source
`IndexColumnBuilder.php`	Class	Class source
`IndexCommentBuilder.php`	Class	Class source
`IndexHintListBuilder.php`	Class	Class source
`IndexKeyBuilder.php`	Class	Class source
`IndexLockBuilder.php`	Class	Class source
`IndexParserBuilder.php`	Class	Class source
`IndexSizeBuilder.php`	Class	Class source
`IndexTypeBuilder.php`	Class	Class source
`InListBuilder.php`	Class	Class source
`InsertBuilder.php`	Class	Class source
`InsertColumnListBuilder.php`	Class	Class source
`InsertStatementBuilder.php`	Class	Class source
`JoinBuilder.php`	Class	Class source
`LikeBuilder.php`	Class	Class source
`LikeExpressionBuilder.php`	Class	Class source
`LimitBuilder.php`	Class	Class source
`OperatorBuilder.php`	Class	Class source
`OrderByAliasBuilder.php`	Class	Class source
`OrderByBracketExpressionBuilder.php`	Class	Class source
`OrderByBuilder.php`	Class	Class source
`OrderByColumnReferenceBuilder.php`	Class	Class source
`OrderByExpressionBuilder.php`	Class	Class source
`OrderByFunctionBuilder.php`	Class	Class source
`OrderByReservedBuilder.php`	Class	Class source
`PositionBuilder.php`	Class	Class source
`PrimaryKeyBuilder.php`	Class	Class source
`ProcedureBuilder.php`	Class	Class source
`QueryBuilder.php`	Class	Class source
`RecordBuilder.php`	Class	Class source
`RefClauseBuilder.php`	Class	Class source
`RefTypeBuilder.php`	Class	Class source
`RenameStatementBuilder.php`	Class	Class source
`ReservedBuilder.php`	Class	Class source
`SchemaBuilder.php`	Class	Class source
`SelectBracketExpressionBuilder.php`	Class	Class source
`SelectBuilder.php`	Class	Class source
`SelectExpressionBuilder.php`	Class	Class source
`SelectStatementBuilder.php`	Class	Class source
`SetBuilder.php`	Class	Class source
`SetExpressionBuilder.php`	Class	Class source
`ShowBuilder.php`	Class	Class source
`ShowStatementBuilder.php`	Class	Class source
`SignBuilder.php`	Class	Class source
`SubQueryBuilder.php`	Class	Class source
`SubTreeBuilder.php`	Class	Class source
`TableBracketExpressionBuilder.php`	Class	Class source
`TableBuilder.php`	Class	Class source
`TableExpressionBuilder.php`	Class	Class source
`TempTableBuilder.php`	Class	Class source
`UpdateBuilder.php`	Class	Class source
`UpdateStatementBuilder.php`	Class	Class source
`UserVariableBuilder.php`	Class	Class source
`ValuesBuilder.php`	Class	Class source
`ViewBuilder.php`	Class	Class source
`WhereBracketExpressionBuilder.php`	Class	Class source
`WhereBuilder.php`	Class	Class source
`WhereExpressionBuilder.php`	Class	Class source

File	Role	Description
`InvalidParameterException.php`	Class	Class source
`UnableToCalculatePositionException.php`	Class	Class source
`UnableToCreateSQLException.php`	Class	Class source
`UnsupportedFeatureException.php`	Class	Class source

File	Role	Description
`LexerSplitter.php`	Class	Class source
`PHPSQLLexer.php`	Class	Class source

File	Role	Description
`AbstractProcessor.php`	Class	Class source
`BracketProcessor.php`	Class	Class source
`ColumnDefinitionProcessor.php`	Class	Class source
`ColumnListProcessor.php`	Class	Class source
`CreateDefinitionProcessor.php`	Class	Class source
`CreateProcessor.php`	Class	Class source
`DefaultProcessor.php`	Class	Class source
`DeleteProcessor.php`	Class	Class source
`DescProcessor.php`	Class	Class source
`DescribeProcessor.php`	Class	Class source
`DropProcessor.php`	Class	Class source
`DuplicateProcessor.php`	Class	Class source
`ExplainProcessor.php`	Class	Class source
`ExpressionListProcessor.php`	Class	Class source
`FromProcessor.php`	Class	Class source
`GroupByProcessor.php`	Class	Class source
`HavingProcessor.php`	Class	Class source
`IndexColumnListProcessor.php`	Class	Class source
`IndexProcessor.php`	Class	Class source
`InsertProcessor.php`	Class	Class source
`IntoProcessor.php`	Class	Class source
`LimitProcessor.php`	Class	Class source
`OptionsProcessor.php`	Class	Class source
`OrderByProcessor.php`	Class	Class source
`PartitionDefinitionProcessor.php`	Class	Class source
`PartitionOptionsProcessor.php`	Class	Class source
`RecordProcessor.php`	Class	Class source
`ReferenceDefinitionProcessor.php`	Class	Class source
`RenameProcessor.php`	Class	Class source
`ReplaceProcessor.php`	Class	Class source
`SelectExpressionProcessor.php`	Class	Class source
`SelectProcessor.php`	Class	Class source
`SetProcessor.php`	Class	Class source
`ShowProcessor.php`	Class	Class source
`SQLChunkProcessor.php`	Class	Class source
`SQLProcessor.php`	Class	Class source
`SubpartitionDefinitionProcessor.php`	Class	Class source
`TableProcessor.php`	Class	Class source
`UnionProcessor.php`	Class	Class source
`UpdateProcessor.php`	Class	Class source
`UsingProcessor.php`	Class	Class source
`ValuesProcessor.php`	Class	Class source
`WhereProcessor.php`	Class	Class source
`WithProcessor.php`	Class	Class source

File	Role	Description
`ExpressionToken.php`	Class	Class source
`ExpressionType.php`	Class	Class source
`PHPSQLParserConstants.php`	Class	Class source

File	Role	Description
`cases` (1 file, 2 directories)
`expected` (2 directories)
`bootstrap.php`	Aux.	Auxiliary script
`readme.txt`	Doc.	Documentation

File	Role	Description
`creator` (55 files)
`parser` (92 files)
`AbstractTestCase.php`	Class	Class source

File	Role	Description
`ascTest.php`	Class	Class source
`count_distinctTest.php`	Class	Class source
`deleteTest.php`	Class	Class source
`functionTest.php`	Class	Class source
`inlistTest.php`	Class	Class source
`insertTest.php`	Class	Class source
`issue100Test.php`	Class	Class source
`issue101Test.php`	Class	Class source
`issue102Test.php`	Class	Class source
`issue104Test.php`	Class	Class source
`issue105Test.php`	Class	Class source
`issue106Test.php`	Class	Class source
`issue110Test.php`	Class	Class source
`issue112Test.php`	Class	Class source
`issue117Test.php`	Class	Class source
`issue118Test.php`	Class	Class source
`issue121Test.php`	Class	Class source
`issue123Test.php`	Class	Class source
`issue124Test.php`	Class	Class source
`issue126Test.php`	Class	Class source
`issue127Test.php`	Class	Class source
`issue129Test.php`	Class	Class source
`issue130Test.php`	Class	Class source
`issue131Test.php`	Class	Class source
`issue132Test.php`	Class	Class source
`issue134Test.php`	Class	Class source
`issue141Test.php`	Class	Class source
`issue144Test.php`	Class	Class source
`issue147Test.php`	Class	Class source
`issue33Test.php`	Class	Class source
`issue57Test.php`	Class	Class source
`issue58Test.php`	Class	Class source
`issue62Test.php`	Class	Class source
`issue63Test.php`	Class	Class source
`issue66Test.php`	Class	Class source
`issue76Test.php`	Class	Class source
`issue78Test.php`	Class	Class source
`issue79Test.php`	Class	Class source
`issue81Test.php`	Class	Class source
`issue83Test.php`	Class	Class source
`issue85Test.php`	Class	Class source
`issue86Test.php`	Class	Class source
`issue87Test.php`	Class	Class source
`issue88Test.php`	Class	Class source
`issue89Test.php`	Class	Class source
`issue92Test.php`	Class	Class source
`issue94Test.php`	Class	Class source
`issue98Test.php`	Class	Class source
`issue_git10Test.php`	Class	Class source
`joinTest.php`	Class	Class source
`leftTest.php`	Class	Class source
`magnusTest.php`	Class	Class source
`tableexprTest.php`	Class	Class source
`updateTest.php`	Class	Class source
`whereTest.php`	Class	Class source

File	Role	Description
`aliasesTest.php`	Class	Class source
`allcolumnsTest.php`	Class	Class source
`backtickTest.php`	Class	Class source
`customfunctionTest.php`	Class	Class source
`deleteTest.php`	Class	Class source
`dropTest.php`	Class	Class source
`fromTest.php`	Class	Class source
`gtltopTest.php`	Class	Class source
`inlistTest.php`	Class	Class source
`insertTest.php`	Class	Class source
`issue102Test.php`	Class	Class source
`issue107Test.php`	Class	Class source
`issue108Test.php`	Class	Class source
`issue117Test.php`	Class	Class source
`issue11Test.php`	Class	Class source
`issue120Test.php`	Class	Class source
`issue122Test.php`	Class	Class source
`issue125Test.php`	Class	Class source
`issue12Test.php`	Class	Class source
`issue131Test.php`	Class	Class source
`issue133Test.php`	Class	Class source
`issue135Test.php`	Class	Class source
`issue136Test.php`	Class	Class source
`issue137Test.php`	Class	Class source
`issue138Test.php`	Class	Class source
`issue139Test.php`	Class	Class source
`issue148Test.php`	Class	Class source
`issue149Test.php`	Class	Class source
`issue150Test.php`	Class	Class source
`issue15Test.php`	Class	Class source
`issue21Test.php`	Class	Class source
`issue25Test.php`	Class	Class source
`issue30Test.php`	Class	Class source
`issue31Test.php`	Class	Class source
`issue32Test.php`	Class	Class source
`issue33Test.php`	Class	Class source
`issue34Test.php`	Class	Class source
`issue36Test.php`	Class	Class source
`issue37Test.php`	Class	Class source
`issue38Test.php`	Class	Class source
`issue39Test.php`	Class	Class source
`issue40Test.php`	Class	Class source
`issue41Test.php`	Class	Class source
`issue42Test.php`	Class	Class source
`issue43Test.php`	Class	Class source
`issue44Test.php`	Class	Class source
`issue45Test.php`	Class	Class source
`issue46Test.php`	Class	Class source
`issue50Test.php`	Class	Class source
`issue51Test.php`	Class	Class source
`issue52Test.php`	Class	Class source
`issue53Test.php`	Class	Class source
`issue54Test.php`	Class	Class source
`issue55Test.php`	Class	Class source
`issue56Test.php`	Class	Class source
`issue60Test.php`	Class	Class source
`issue61Test.php`	Class	Class source
`issue62Test.php`	Class	Class source
`issue65Test.php`	Class	Class source
`issue67Test.php`	Class	Class source
`issue68Test.php`	Class	Class source
`issue69Test.php`	Class	Class source
`issue70Test.php`	Class	Class source
`issue71Test.php`	Class	Class source
`issue72Test.php`	Class	Class source
`issue74Test.php`	Class	Class source
`issue78Test.php`	Class	Class source
`issue79Test.php`	Class	Class source
`issue80Test.php`	Class	Class source
`issue82Test.php`	Class	Class source
`issue84Test.php`	Class	Class source
`issue87Test.php`	Class	Class source
`issue90Test.php`	Class	Class source
`issue91Test.php`	Class	Class source
`issue93Test.php`	Class	Class source
`issue94Test.php`	Class	Class source
`issue95Test.php`	Class	Class source
`issue97Test.php`	Class	Class source
`issue98Test.php`	Class	Class source
`issue_git11Test.php`	Class	Class source
`leftTest.php`	Class	Class source
`manualTest.php`	Class	Class source
`nestedTest.php`	Class	Class source
`positionsTest.php`	Class	Class source
`selectTest.php`	Class	Class source
`showTest.php`	Class	Class source
`subselectTest.php`	Class	Class source
`tableoptionsTest.php`	Class	Class source
`unionTest.php`	Class	Class source
`updateTest.php`	Class	Class source
`variablesTest.php`	Class	Class source
`zeroTest.php`	Class	Class source

File	Role	Description
`asc.sql`	Data	Auxiliary data
`delete.sql`	Data	Auxiliary data
`distinct.sql`	Data	Auxiliary data
`function.sql`	Data	Auxiliary data
`inlist.sql`	Data	Auxiliary data
`insert1.sql`	Data	Auxiliary data
`insert2.sql`	Data	Auxiliary data
`insert3.sql`	Data	Auxiliary data
`issue100.sql`	Data	Auxiliary data
`issue101.sql`	Data	Auxiliary data
`issue102.sql`	Data	Auxiliary data
`issue104.sql`	Data	Auxiliary data
`issue105.sql`	Data	Auxiliary data
`issue106.sql`	Data	Auxiliary data
`issue110.sql`	Data	Auxiliary data
`issue112.sql`	Data	Auxiliary data
`issue117.sql`	Data	Auxiliary data
`issue118.sql`	Data	Auxiliary data
`issue121.sql`	Data	Auxiliary data
`issue123.sql`	Data	Auxiliary data
`issue124.sql`	Data	Auxiliary data
`issue126.sql`	Data	Auxiliary data
`issue127.sql`	Data	Auxiliary data
`issue129.sql`	Data	Auxiliary data
`issue130.sql`	Data	Auxiliary data
`issue131.sql`	Data	Auxiliary data
`issue132.sql`	Data	Auxiliary data
`issue134.sql`	Data	Auxiliary data
`issue141.sql`	Data	Auxiliary data
`issue144.sql`	Data	Auxiliary data
`issue147.sql`	Data	Auxiliary data
`issue33a.sql`	Data	Auxiliary data
`issue33b.sql`	Data	Auxiliary data
`issue33c.sql`	Data	Auxiliary data
`issue33d.sql`	Data	Auxiliary data
`issue33e.sql`	Data	Auxiliary data
`issue33f.sql`	Data	Auxiliary data
`issue33g.sql`	Data	Auxiliary data
`issue33h.sql`	Data	Auxiliary data
`issue33i.sql`	Data	Auxiliary data
`issue33j.sql`	Data	Auxiliary data
`issue33k.sql`	Data	Auxiliary data
`issue33l.sql`	Data	Auxiliary data
`issue33m.sql`	Data	Auxiliary data
`issue57.sql`	Data	Auxiliary data
`issue58.sql`	Data	Auxiliary data
`issue62a.sql`	Data	Auxiliary data
`issue62b.sql`	Data	Auxiliary data
`issue62c.sql`	Data	Auxiliary data
`issue62d.sql`	Data	Auxiliary data
`issue62e.sql`	Data	Auxiliary data
`issue62f.sql`	Data	Auxiliary data
`issue62g.sql`	Data	Auxiliary data
`issue62h.sql`	Data	Auxiliary data
`issue62i.sql`	Data	Auxiliary data
`issue62j.sql`	Data	Auxiliary data
`issue62k.sql`	Data	Auxiliary data
`issue62l.sql`	Data	Auxiliary data
`issue62m.sql`	Data	Auxiliary data
`issue62n.sql`	Data	Auxiliary data
`issue62o.sql`	Data	Auxiliary data
`issue62p.sql`	Data	Auxiliary data
`issue62q.sql`	Data	Auxiliary data
`issue62r.sql`	Data	Auxiliary data
`issue63a.sql`	Data	Auxiliary data
`issue63b.sql`	Data	Auxiliary data
`issue63c.sql`	Data	Auxiliary data
`issue66.sql`	Data	Auxiliary data
`issue76a.sql`	Data	Auxiliary data
`issue76b.sql`	Data	Auxiliary data
`issue78a.sql`	Data	Auxiliary data
`issue78b.sql`	Data	Auxiliary data
`issue78c.sql`	Data	Auxiliary data
`issue78d.sql`	Data	Auxiliary data
`issue78e.sql`	Data	Auxiliary data
`issue79a.sql`	Data	Auxiliary data
`issue81.sql`	Data	Auxiliary data
`issue83a.sql`	Data	Auxiliary data
`issue83b.sql`	Data	Auxiliary data
`issue83c.sql`	Data	Auxiliary data
`issue85.sql`	Data	Auxiliary data
`issue86.sql`	Data	Auxiliary data
`issue87.sql`	Data	Auxiliary data
`issue88.sql`	Data	Auxiliary data
`issue89.sql`	Data	Auxiliary data
`issue92.sql`	Data	Auxiliary data
`issue94.sql`	Data	Auxiliary data
`issue98.sql`	Data	Auxiliary data
`issue_git10.sql`	Data	Auxiliary data
`join.sql`	Data	Auxiliary data
`left.sql`	Data	Auxiliary data
`magnus.sql`	Data	Auxiliary data
`tableexpr.sql`	Data	Auxiliary data
`update.sql`	Data	Auxiliary data
`where.sql`	Data	Auxiliary data

File	Role	Description
`alias1.serialized`	Data	Auxiliary data
`alias2.serialized`	Data	Auxiliary data
`alias3.serialized`	Data	Auxiliary data
`alias4.serialized`	Data	Auxiliary data
`allcolumns1.serialized`	Data	Auxiliary data
`allcolumns2.serialized`	Data	Auxiliary data
`allcolumns3.serialized`	Data	Auxiliary data
`allcolumns4.serialized`	Data	Auxiliary data
`allcolumns5.serialized`	Data	Auxiliary data
`backtick1.serialized`	Data	Auxiliary data
`delete1.serialized`	Data	Auxiliary data
`delete2.serialized`	Data	Auxiliary data
`delete3.serialized`	Data	Auxiliary data
`drop.serialized`	Data	Auxiliary data
`gtltop.serialized`	Data	Auxiliary data
`inlist1.serialized`	Data	Auxiliary data
`insert1.serialized`	Data	Auxiliary data
`insert2.serialized`	Data	Auxiliary data
`insert3.serialized`	Data	Auxiliary data
`issue102.serialized`	Data	Auxiliary data
`issue11.serialized`	Data	Auxiliary data
`issue117.serialized`	Data	Auxiliary data
`issue12.serialized`	Data	Auxiliary data
`issue120.serialized`	Data	Auxiliary data
`issue122.serialized`	Data	Auxiliary data
`issue125.serialized`	Data	Auxiliary data
`issue131.serialized`	Data	Auxiliary data
`issue133a.serialized`	Data	Auxiliary data
`issue133b.serialized`	Data	Auxiliary data
`issue135.serialized`	Data	Auxiliary data
`issue136a.serialized`	Data	Auxiliary data
`issue136b.serialized`	Data	Auxiliary data
`issue137.serialized`	Data	Auxiliary data
`issue138.serialized`	Data	Auxiliary data
`issue139.serialized`	Data	Auxiliary data
`issue148.serialized`	Data	Auxiliary data
`issue149.serialized`	Data	Auxiliary data
`issue15.serialized`	Data	Auxiliary data
`issue21.serialized`	Data	Auxiliary data
`issue25.serialized`	Data	Auxiliary data
`issue30.serialized`	Data	Auxiliary data
`issue31.serialized`	Data	Auxiliary data
`issue32.serialized`	Data	Auxiliary data
`issue33a.serialized`	Data	Auxiliary data
`issue33b.serialized`	Data	Auxiliary data
`issue33c.serialized`	Data	Auxiliary data
`issue33d.serialized`	Data	Auxiliary data
`issue33e.serialized`	Data	Auxiliary data
`issue33f.serialized`	Data	Auxiliary data
`issue33g.serialized`	Data	Auxiliary data
`issue33h.serialized`	Data	Auxiliary data
`issue33i.serialized`	Data	Auxiliary data
`issue33j.serialized`	Data	Auxiliary data
`issue33k.serialized`	Data	Auxiliary data
`issue33l.serialized`	Data	Auxiliary data
`issue33m.serialized`	Data	Auxiliary data
`issue33n.serialized`	Data	Auxiliary data
`issue33o.serialized`	Data	Auxiliary data
`issue33p.serialized`	Data	Auxiliary data
`issue33q.serialized`	Data	Auxiliary data
`issue33r.serialized`	Data	Auxiliary data
`issue33s.serialized`	Data	Auxiliary data
`issue33t.serialized`	Data	Auxiliary data
`issue34a.serialized`	Data	Auxiliary data
`issue34b.serialized`	Data	Auxiliary data
`issue36a.serialized`	Data	Auxiliary data
`issue36b.serialized`	Data	Auxiliary data
`issue36c.serialized`	Data	Auxiliary data
`issue37.serialized`	Data	Auxiliary data
`issue38.serialized`	Data	Auxiliary data
`issue39.serialized`	Data	Auxiliary data
`issue40a.serialized`	Data	Auxiliary data
`issue40b.serialized`	Data	Auxiliary data
`issue41.serialized`	Data	Auxiliary data
`issue42.serialized`	Data	Auxiliary data
`issue43.serialized`	Data	Auxiliary data
`issue44.serialized`	Data	Auxiliary data
`issue45.serialized`	Data	Auxiliary data
`issue51.serialized`	Data	Auxiliary data
`issue52.serialized`	Data	Auxiliary data
`issue53a.serialized`	Data	Auxiliary data
`issue53b.serialized`	Data	Auxiliary data
`issue54.serialized`	Data	Auxiliary data
`issue55a.serialized`	Data	Auxiliary data
`issue55b.serialized`	Data	Auxiliary data
`issue61.serialized`	Data	Auxiliary data
`issue62a.serialized`	Data	Auxiliary data
`issue62b.serialized`	Data	Auxiliary data
`issue62c.serialized`	Data	Auxiliary data
`issue65.serialized`	Data	Auxiliary data
`issue67a.serialized`	Data	Auxiliary data
`issue67b.serialized`	Data	Auxiliary data
`issue68.serialized`	Data	Auxiliary data
`issue69.serialized`	Data	Auxiliary data
`issue70.serialized`	Data	Auxiliary data
`issue71a.serialized`	Data	Auxiliary data
`issue71b.serialized`	Data	Auxiliary data
`issue72.serialized`	Data	Auxiliary data
`issue74a.serialized`	Data	Auxiliary data
`issue74b.serialized`	Data	Auxiliary data
`issue74c.serialized`	Data	Auxiliary data
`issue74d.serialized`	Data	Auxiliary data
`issue74e.serialized`	Data	Auxiliary data
`issue74f.serialized`	Data	Auxiliary data
`issue78a.serialized`	Data	Auxiliary data
`issue78b.serialized`	Data	Auxiliary data
`issue78c.serialized`	Data	Auxiliary data
`issue78d.serialized`	Data	Auxiliary data
`issue78e.serialized`	Data	Auxiliary data
`issue79a.serialized`	Data	Auxiliary data
`issue79b.serialized`	Data	Auxiliary data
`issue80a.serialized`	Data	Auxiliary data
`issue80b.serialized`	Data	Auxiliary data
`issue82.serialized`	Data	Auxiliary data
`issue84a.serialized`	Data	Auxiliary data
`issue84b.serialized`	Data	Auxiliary data
`issue84c.serialized`	Data	Auxiliary data
`issue87a.serialized`	Data	Auxiliary data
`issue87b.serialized`	Data	Auxiliary data
`issue90.serialized`	Data	Auxiliary data
`issue91.serialized`	Data	Auxiliary data
`issue93.serialized`	Data	Auxiliary data
`issue94.serialized`	Data	Auxiliary data
`issue97.serialized`	Data	Auxiliary data
`issue98.serialized`	Data	Auxiliary data
`issue_git11.serialized`	Data	Auxiliary data
`left1.serialized`	Data	Auxiliary data
`left2.serialized`	Data	Auxiliary data
`manual.serialized`	Data	Auxiliary data
`nested1.serialized`	Data	Auxiliary data
`nested2.serialized`	Data	Auxiliary data
`positions1.serialized`	Data	Auxiliary data
`select1.serialized`	Data	Auxiliary data
`select2.serialized`	Data	Auxiliary data
`show1.serialized`	Data	Auxiliary data
`show2.serialized`	Data	Auxiliary data
`show3.serialized`	Data	Auxiliary data
`show4.serialized`	Data	Auxiliary data
`show5.serialized`	Data	Auxiliary data
`subselect1.serialized`	Data	Auxiliary data
`subselect2.serialized`	Data	Auxiliary data
`tableoptions1.serialized`	Data	Auxiliary data
`union1.serialized`	Data	Auxiliary data
`union2.serialized`	Data	Auxiliary data
`update1.serialized`	Data	Auxiliary data
`update2.serialized`	Data	Auxiliary data
`variables1.serialized`	Data	Auxiliary data
`variables2.serialized`	Data	Auxiliary data

File	Role	Description
`Complex-Example.md`	Data	Auxiliary data
`Downloads.md`	Data	Auxiliary data
`Parser-Manual.md`	Example	Example script
`Roadmap.md`	Data	Auxiliary data
`User-Response.md`	Data	Auxiliary data

	php-sql-parser-2018-11-20.zip 637KB
	php-sql-parser-2018-11-20.tar.gz 159KB
	Install with Composer