Getting around link table with cyclic reference in duckdb
I’m working on a financial data app where I want to track different types of securities (stocks, options, futures, bonds, etc.) and corresponding daily quotes. Currently I have a separate table for each type of security, e.g. for stocks the table looks like: