[BUG] TablesNamesFinder misses tables or throws for piped queries, DML statements and analytic clauses #2478

// 1. piped query: returns []
TablesNamesFinder.findTables("FROM MY_TABLE1 "
        + "|> WHERE id IN (SELECT id FROM MY_TABLE2) "
        + "|> LEFT JOIN (SELECT item FROM MY_TABLE3) AS t3 ON t3.item = item "
        + "|> UNION ALL (SELECT * FROM MY_TABLE4) "
        + "|> SELECT item");

// 2. DELETE with WITH: returns [cte, MY_TABLE1]
TablesNamesFinder.findTables(
        "WITH cte AS (SELECT * FROM MY_TABLE2) DELETE FROM MY_TABLE1 WHERE id IN (SELECT id FROM cte)");

// 3. MERGE: returns [src, MY_TABLE1]
TablesNamesFinder.findTables("MERGE INTO MY_TABLE1 USING src "
        + "ON id IN (SELECT id FROM MY_TABLE3) "
        + "WHEN MATCHED THEN UPDATE SET v = (SELECT MAX(v) FROM MY_TABLE4)");

// 4. INSERT actions / clauses: returns [MY_TABLE1]
TablesNamesFinder.findTables(
        "INSERT INTO MY_TABLE1 (a) VALUES (1) ON DUPLICATE KEY UPDATE b = (SELECT x FROM MY_TABLE2)");
TablesNamesFinder.findTables("UPDATE MY_TABLE1 SET a = 1 RETURNING (SELECT x FROM MY_TABLE2)");

// 5. data modifying CTE: ClassCastException (ParenthesedDelete cannot be cast to ParenthesedSelect)
TablesNamesFinder.findTables(
        "WITH del AS (DELETE FROM MY_TABLE2) INSERT INTO MY_TABLE1 SELECT * FROM del");

// 6. analytic function with function level ORDER BY: NullPointerException
//    ("...getOrderByElements()" is null because the return value of ...")
TablesNamesFinder.findTables(
        "SELECT string_agg(name, ',' ORDER BY id) OVER (PARTITION BY grp) FROM MY_TABLE1");