sqlftw icon indicating copy to clipboard operation
sqlftw copied to clipboard

SQL lexer, parser, model and static analysis in PHP (for MySQL dialect)

Results 9 sqlftw issues
Sort by recently updated
recently updated
newest added

could you please add the LICSENSE this project is using?

parsing fails on `=` `SELECT t1.x IS NULL = t2.x AS col FROM t AS t1, t AS t2 ORDER BY col;`

bug

In the readme I found > another will hopefully help PHPStan (static analysis tool for PHP) better understand SQL queries and their results Since I am working on https://github.com/staabm/phpstan-dba -...

feature request

when running the query `SELECT COALESCE(null, gesperrt, freigabe1u1) from ada` thru the ast, I get the following function call expression: ![grafik](https://user-images.githubusercontent.com/120441/218795081-4943bfc1-0269-4a1d-a12e-405a36a348d3.png) the `SimpleName ` of the arguments atm only contain...

feature request
blocked

The library is quite cool. Thanks. Have you been thinking of a feature that would ease AST traversal? Perhaps something like https://www.doctrine-project.org/projects/doctrine-orm/en/2.13/cookbook/dql-custom-walkers.html or even something better :-P Things like collecting...

feature request

Highlight PHP snippet

eases working with `Join`s without explicitly handling all separate Join types

Hello, I came across bug when creating new instance of `AlterTableCommand` from old one. ```php $actions = getMeNewActions($originalCommand); $newCommand = new AlterTableCommand( $originalCommand->getTable(), $actions, $originalCommand->getAlterOptions(), $originalCommand->getOptionsList(), // this causes the...