Persisted SQL is used quite a lot, and best practice in many case: stored procedures containing the query returning just a ref cursor for example, or sql (materialized) views where users don't get direct access to the underlying tables.