In the docs it says that "'Neither timestamp_expression nor version can be subqueries."

So it does sound challenging. I also tried playing with widgets to see if it could be populated using SQL but didn't succeed. With python it's really easy to do.