cossacklabs / acra

Database security suite. Database proxy with field-level encryption, search through encrypted data, SQL injections prevention, intrusion detection, honeypots. Supports client-side and proxy-side ("transparent") encryption. SQL, NoSQL.
https://www.cossacklabs.com/acra/
Apache License 2.0
1.33k stars 128 forks source link

Extend limit&offset statements #603

Closed Lagovas closed 1 year ago

Lagovas commented 1 year ago

Extended parser with postgresql specific statements syntax and refactored rendering from the AST to the string in same format as it was parsed. But wasn't added support of cursor specific syntax for PostgreSQL with FETCH + limit&offset. It is much more complicated and should be implemented together with cursor's support. PostgreSQL's format - https://www.postgresql.org/docs/current/sql-select.html#SQL-LIMIT MySQL's format - https://dev.mysql.com/doc/refman/8.0/en/select.html

Checklist