wondering if we rewrite this as CTE that might speed things up? need to check some queries to confirm. https://github.com/saihaj/DOGE-AI/blob/ba8916687b6f5ff174e00baf5ad3b601e8e21cd2/agent/src/twitter/knowledge-base.ts#L104-L125
wondering if we rewrite this as CTE that might speed things up? need to check some queries to confirm.
https://github.com/saihaj/DOGE-AI/blob/ba8916687b6f5ff174e00baf5ad3b601e8e21cd2/agent/src/twitter/knowledge-base.ts#L104-L125