What are the limitations of JSqlParser?

[DeepikaEDevadiga]

Is it possible for the JSQL Parser to successfully parse subqueries that are enclosed within multiple sets of parentheses?

[manticore-projects]

Yes, especially JSQLParser 4.7 Snapshot supports nested parentheses very well: https://manticore-projects.com/JSQLParser/migration.html#brackets

[DeepikaEDevadiga]

Thanks for the reply

[DeepikaEDevadiga]

SELECT 1 FROM customers c WHERE EXIST (SELECT 1 FROM orders o JOIN order_items oi ON o.order_id = oi.order_id WHERE c.customer_id = o.customer_id AND oi.product_id IN ( SELECT product_id FROM product_sales WHERE sale_date >= (SELECT MAX(sale_date) FROM sales)));
Can the parser handle the complexity of the given query? I'm working on analyzing the query to identify the tables present along with their corresponding alias names. However, I'm facing difficulties in parsing the query enclosed within parentheses, which is hindering my ability to achieve the desired output.

[manticore-projects]

Yes, you can try it online here.