The Challenge of Writing a Blog Post About JSON B to Record Set

A lot of the JSON B to record set use cases that we found like stack overflow and blog posts or whatever, they kind of just showed it with raw SQL. That's another issue with trying to use it within the Ecto landscape because you can't have multiple schemas within the same from clause. So trying to figure out how to get around that was also another challenge that we encountered. The way that we resolve that one was trying to use a lateral join to be able to use the record set that's being returned from that function with the original base query.