Dynamic Query for pl sql (HANA translation)

Here's a the HANA translation of the Oracle dynamic query shared by
Mornin'