Is it possible to drill down into metabase with sql query? I realize that is it possible to drill down with GUI query builder, but with sql query I haven't found a way
No, since that would require Metabase being able to parse SQL to modify it.
You can however create a nested question or model based on SQL, which would give you drill-through functionality, since you're drilling to that instead of to the actual SQL.
Ah, I see, thanks flamber, I'll see if I can do the questions in the GUI!