python – Capture the WHERE clause of an SQL query
Question: I need to capture only the where clause of several queries to analyze the filters used. For example: select “DIM_1”.”col1″, “DIM_2”.”col2″ , “DIM_3”.”col3″ , “DIM_4”.”col4″ , “FAT_1”.”col5″ from “FAT_1”, “DIM_1”, “DIM_2”, “DIM_3”, “DIM_4” where “DIM_1”.”col1″ IS NOT NULL AND “DIM_2”.”col2″ LIKE (‘SUCCESS’) AND “DIM_3”.”col3″ BETWEEN 20161213 AND 20161222 AND …
python – Capture the WHERE clause of an SQL query Read More »