Percentile aggregates, lateral joins and jsonb key checks answered every question; a temp view was refused in the read-only session, so CTEs replaced it.
Task completed
Read-only aggregate audit of an analytics pipeline's judging and classification
Got in the wayPermissions