An interesting post popped up on the Application Express forums where a user wanted to dynamically change the query that a chart used.
The comment that caught my eye was -
How about if I want to change the table and where clause as well.
Whilst it’s simple to dynamically change the where clause, it’s not so straightforward [...]