Seeking thoughts on advantages of the Repo.transact pattern vs disadvantages I’ve read about Ecto.Multi

Which article? Was looking through this thread and can’t find it.

More to the point, don’t get, one, and all return nil (or [nil]) because a query that returns 0 results is not an error? It’s a successful query that returned zero rows represented by nil. I’ve always operated under the idea that :ok/:error tuples describe the result of some side effect not under our control or a pure function that receives data we don’t control, like passing user-generated HTML to Floki.parse_document.