Wondering if SQLcl Projects is usable at all with the APEX Application Development Service?
As if we look at Service Comparison → Database Access from https://apex.oracle.com/en/learn/getting-started/pricing/, it shows (by exclusion) that “_Direct database connectivity_” is not available with this service. And Projects requires SQLcl which does require direct JDBC database connectivity to the best of my knowledge.
So is there any workaround by using REST database access or Database Actions (under “Browser-based tools”) in some way to use project commands?
(I'm doubtful that there are any options – I suspect that we might have to follow https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/upgrade-apex-transaction-processing.html to upgrade it to a Transaction Processing ADB if using Projects is required. But adding some sort of workaround/option would be a nice enhancement IMO.)