Andrew, you captured some “zen of Metabase” very nicely here: 
Note, I’m reading the excerpt above with ideas on ways to use Metabase shared in the whole Best way to overcome lack of joins thread in mind. I think that is well worth a read if you are coming to Metabase with an “I-need-SQL-to-build-something-powerful” viewpoint.