Repo.all() will run the query you are passing to it, so you will want to compose the full query before passing it in. Your last example is close, try something like Meeting |> where(user_id: current_user.id) |> Repo.all()
It still won’t teach you SQL - you’re still on your own for that …
We’re also going assume that you’re comfortable working with relational databases and SQL. You don’t need to be an expert, but you should be familiar with tables, columns, indexes and how to write queries. There are many online tutorials that can walk you through the basics.
Sure - however AR isn’t available in Ecto (or Phoenix) and I don’t know how much effort it would be to set up a piggybacked environment just for the purpose of generating SQL from active record.
For the purposes of getting the most out of Programming Ecto http://www.postgresqltutorial.com/
is probably the best bet. The bits of the tutorial I have come across seem to do the job.