- SELECT report_lines.id,
- reports.id AS report_id,
- market_configs.market_name,
- market_configs.id AS market_id,
- reports.date AS report_date,
- report_lines.date,
- report_lines.payload
- FROM report_lines
- JOIN reports ON reports.id = report_lines.report_id
- JOIN market_configs ON reports.market_config_id = market_configs.id
- WHERE report_lines.payload::jsonb->'checkpoint' IS NOT NULL`,
- `CREATE INDEX checkpoints_idx ON report_lines ((payload->>'checkpoint'))`,
+ SELECT report_lines.id,
+ reports.id AS report_id,
+ market_configs.market_name,
+ market_configs.id AS market_id,
+ reports.date AS report_date,
+ report_lines.date,
+ report_lines.payload
+ FROM report_lines
+ JOIN reports ON reports.id = report_lines.report_id
+ JOIN market_configs ON reports.market_config_id = market_configs.id
+ WHERE report_lines.payload::jsonb->>'checkpoint' IS NOT NULL`,
+ `CREATE INDEX checkpoints_idx ON report_lines ((payload->>'checkpoint'))`,