MySQL support (procedural language)

nene / sql-parser-cst

Parses SQL into Concrete Syntax Tree (CST)

GNU General Public License v2.0

136 stars 9 forks source link

MySQL support (procedural language) #60

Open nene opened 10 months ago

nene commented 10 months ago

Procedural language

[x] DECLARE
[ ] SET
- [x] basic syntax
- [x] multi-variable assignment
- [ ] GLOBAL, PERSIST, PERSIST_ONLY, SESSION
[x] BEGIN .. END block
[x] procedural CASE
[x] IF .. THEN .. ELSEIF .. ELSE .. END IF
[x] block labels
[x] LOOP .. END LOOP
[x] REPEAT .. UNTIL .. END REPEAT
[x] WHILE cond DO .. END WHILE
[x] LEAVE
[x] ITERATE
[x] RETURN
[x] CALL

TonyGravagno commented 3 weeks ago

I hope this is the right place to add the DELIMITER command. It's old and standard: https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html

It's not supported in the parser.

I'd be happy to add it if I spoke PegJS, sorry.

nene commented 3 weeks ago

Better to create a separate issue for this as this DELIMITER is really quite a different beast. It's not really part of the language recognized by MySQL server, it's a command specific to the mysql client program (among several other commands, like use).

Created a separate issue here: #89

Frankly I'm not quite sure how to go about implementing this. There possibly needs to be some switch to toggle the parser into mysql client-mode.