Description

ProxySQL currently supports standard PostgreSQL transaction commands (BEGIN, COMMIT, ROLLBACK, SAVEPOINT, etc.), but PostgreSQL also defines several aliases that should be recognized as equivalent.

Transaction command aliases to add

• START TRANSACTION → same as BEGIN
• END → same as COMMIT
• ABORT → same as ROLLBACK

Additional handling

Add support for ROLLBACK AND CHAIN, which rolls back the current transaction and immediately starts a new one with the same characteristics.
ROLLBACK AND NO CHAIN (or plain ROLLBACK) should just end the current transaction as usual.