js-sql-parser

js-sql-parser copied to clipboard

allow select from a union select

1

give the capability to parse query from a union select

chack-os

Added support for LEFT and RIGHT functions

1

Added support for the below functions ``` SELECT LEFT('SQL Tutorial', 3) AS ExtractString; SELECT RIGHT('SQL Tutorial', 3) AS ExtractString; ``` Earlier the parser was breaking as LEFT and RIGHT keywords...

KNaved

LEFT(string, charcters length), RIGHT(string, characters length) not getting exact result

1

LEFT(string, charcters length), RIGHT(string, characters length) not getting exact result as we expect instead throw error

T-Deepthy

Support value placeholders with '@'

1

See this as a TODO on the readme, just wanted to create an issue to track progress and so folks could +1 if desired. Thanks!

kylechadha

A little more coverage of sql queries would be very useful. ``` update TABLE_NAME set COLUMN_NAME=0 where ID_COLUMN=1 ```

adminy

feature: Added support for simple CAST

1

This will not handle all versions of CAST but will handle a simple case like CAST(pct*100 AS int) The query mentioned in #9 was used as the test. ``` select...

mlilius

If the sql string ends with a comment without a trailing newline it fails. This change make it handle this case. I included a test for this as well.

mlilius

Implement INSERT and UPDATE parsing

2

Implements parsing for INSERT and UPDATE queries, per the MySQL 5.7 grammar. Includes pretty printing + test cases. (Note: for my own purposes, I've published this branch under `@gpittarelli/js-sql-parser`)

gpittarelli

allow [$:] as prefix and plain ? for prepared statements

1

This allows handling of the $-prefix (postgresql and sequelize bind), :-previx (PHP PDO and sequelize replace) and single ? (most DBS for prepared steatement. But this PR allows this placeholder...

oger000

Add test case to check release code available

1

#22

albin3