Remove FROM DUAL

Proprietary

Removes the FROM DUAL that Oracle requires on a query selecting no table, as PostgreSQL and other databases accept a SELECT without a FROM clause.

org.openrewrite.sql.RemoveFromDual
mod run . --recipe=org.openrewrite.sql.RemoveFromDual

Install it once from Recipe actions, then run it on every repository under the current directory. New to the Moderne CLI? Set it up.