QuickSQL is not available

Oracle APEX 23.2 was made generally available earlier this month ( November 2023 ). The announcement mentions some new functionality highlights but the release notes are more thorough in going through what is new. What this blog post is particularly interest in is this one…

Quick SQL Updates

Create, maintain, and review application data models with minimal typing, lighting-fast SQL generation, and a built-in entity relationship diagram.

apex.oracle.com

Quick SQL is a markdown-like shorthand syntax that expands to standards-based Oracle SQL. It is useful to rapidly design and prototype data models. Previously, Quick SQL was only available within APEX but it is now available at https://github.com/oracle/quicksql and a distribution of Quick SQL is available through ORDS 23.3.0.

Within APEX the feature is a utility accessible from the SQL Workshop menu.

However, if you are running APEX 23.2 to use Quick SQL you must be running it with at least ORDS 23.3.0 to avoid this error message…

QuickSQL is not available. This is likely due to an insufficient version of ORDS. Minimum ORDS version required is 23.3.

Solution is simple. Upgrade to ORDS 23.3.0 which was released October 23rd 2023. See oracle.com/rest for download link, etc. In other words, it’s…

What about the Autonomous Database?

At the time of writing the hosted Autonomous Database service offerings on cloud.oracle.com has not been upgraded to ORDS 23.3.0 yet. The current workaround is to use Customer Managed ORDS with Autonomous Database. Although the version of ORDS Metadata in your Autonomous Database will be ORDS 23.2.3 it will work fine with ORDS 23.3.0.

December Update on Autonomous Database

Most Autonomous Database production regions are running ORDS 23.3.0 now so this Quick SQL is not available issue should no longer occur.