Need an example for using fetch_many with the query_as function

I would like to do multiple queries in one go and heard this is what I should use, but it's not clear to me how to do it. Are there any examples?