Bob Files

Changed

• PostgreSQL single-column relationship loaders — both the slice relationship query (<Parent>Slice.<Rel>) and the batch count method (<Parent>Slice.LoadCount<Rel>) — now filter related rows with col = ANY($1) instead of col IN (SELECT unnest($1)), so the query planner can use an index scan on the foreign key instead of a Seq Scan + Hash Semi Join. Composite-key relationships keep the existing IN (SELECT unnest(...)) form. (thanks @sandonemaki)

Fixed

• Fixed PostgreSQL generated query parsing for CTEs that use table functions in FROM (for example unnest(...) AS alias), which could incorrectly widen CTE spans and generate malformed query mods such as duplicated outer SELECT projections.

Full Changelog: https://github.com/stephenafamo/bob/compare/v0.47.0...v0.48.0