PostgreSQL query "WITH..AS" returns empty table

Before Qlik Sense February 2019 (ODBC Connector package 5.18.1), PostgreSQL query "WITH..AS" (https://www.postgresql.org/docs/9.1/queries-with.html) can be executed in Qlik Sense.

In Qlik Sense February 2019, this is considered as a non-select query. According to documentation (https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/How-to-load-without-SELECT.htm), such query can be executed by setting allow-nonselect-queries to true in connector config file and adding  !EXECUTE_NON_SELECT_QUERY keyword to the end of the query.

With all these implemented, app reload finishes without throwing errors. However, after the reload, no data is loaded and data model only shows one table named "skip_loading"without any data. 

• Qlik Sense February 2019

While waiting for a fix of bug QVXODBC-1646, a work-around solution is to wrap WITH...AS query in an outer SELECT * query. So the original statement SQL <WITH...AS query> EXECUTE_NON_SELECT_QUERY; should become the following:

SQL SELECT * FROM (

<WITH...AS query>

) AS TempTable;