Hi - fairly new to looker so appreciate the advice here.
I want to be able to query a view or PDT from sql runner. That way, I can run a query in SQL runner in a few lines of code (e.g. SELECT * from view1 LEFT JOIN view2 USING (id)), but that code would represent arbitrarily complex logic (e.g., if pdt1 and pdt2 are themselves generated from queries each 500 lines of code).
Is this possible? An obstacle I keep running into is wanting to query on the fly in sql runner but not able to abstract away large, recurring subqueries.