so i love the patterns and the templates in the editor
im trying to create my own patterns
im sure this is a basic question but ive been googling
and am getting really confused as to the order of operations
in a standard query type of last-3-posts.php
<!-- wp:query {"queryId":1,"query":{"perPage":"3","pages":0,"offset":"0","postType":"post","order":"desc","orderBy":"date","author":"","search":"","exclude":[],"sticky":"","inherit":false},"align":"wide","layout":{"type":"default"}} -->
ok but what if i wanted to do a join query or a query on a non-standard table
ie ive created a new table called mission_meta
where mission_meta has a foreign key to posts
and i want to return that data as well
do i do it in php first and then fill out the pattern template
(how to then populate the pattern?)
or can i call a wp:query with a join?
any pointers would be greatly apprec
thanks!