CTE expressions are supported with the `prepareQuery` option.
https://spark.apache.org/docs/latest/sql-data-sources-jdbc.html
A prefix that will form the final query together with query. As the specified query will be parenthesized as a subquery i...