-- • Step 01 : Optimized 'pttype' filtering performance using range scan patterns. -- • Step 02 : Implemented Sorted Subquery (Derived Table) with row-count forcing -- to prevent dynamic user-variable ...
Six tools covering the full Socrata workflow — portal discovery, dataset search, schema inspection, SoQL querying, and DuckDB-powered analytical SQL over large result sets: ...