Optimize ingestion metadata reads

[pmbrull]

Let's see if we can figure out a full-fledged query we can run to get all necessary table data etc.

The less time we need to keep a connection open with the database, the better