code insights: add Postgres migrations foundation

Created by: slimsag

(See #17218 (closed) for general plan / explanation of the work being done on code insights.)

Reuse what we have in migrations/ to build DB migration foundation for TimescaleDB (we can do this since its just Postgres.)