However, the dynamic SQL is still at a disadvantage. The execute immediate still does its parse, but it uses SQL sharing to resolve the statement. It would be ideal if PL/SQL would allow us to ...

Dynamic Data Masking in SQL Server 2016 Dynamic data masking ensures that non-privileged ... Privileged logins are those logins that get unmasked data in their query result sets. Masking rules define ...

In other words, despite the fact that the motivation for SQL was to use standardized declarative queries, in the real world you see lots of database-specific procedural server programming.