sql_mode="oracle" should provide dbms_sql

https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_sql.htm#i996963

"The DBMS_SQL package provides an interface to use dynamic SQL to parse any data manipulation language (DML) or data definition language (DDL) statement using PL/SQL. For example, you can enter a DROP TABLE statement from within a stored procedure by using the PARSE procedure supplied with the DBMS_SQL package."

We can provide a package on install that calls our parsing functions.