SQL Dump Parser is a lightweight Java library designed to parse SQL dump files, focusing on handling SQL statements and tokens from a given input string. The library supports basic SQL syntax, ...

Using SQL WITH statements (CTEs) often result in much cleaner queries. However in PostgreSQL, CTEs are optimisation fences which can lead to worse performance. The goal of this project is to parse a ...

This is done purposefully to illustrate how complex the server-side code can get when using delimited strings as a solution to this problem. The complexity increases because multiple loops are ...