SQL

Summary: Notes on SQL, query engines, and database tools. Last updated: 2026-08-20

---

2026

• Places Insights on BigQuery: Guide to querying Google Places data in BigQuery and aggregating results using H3 hexagonal grids for site selection, competitive analysis, and commercial density mapping — joins Places data with Overture Maps street geometries. Related: Data. Keywords: SQL, BigQuery, Google Places API, H3, site selection, Overture Maps, location intelligence

• GeoSQL: A Claude/Codex skill for data scientists and analysts working with geospatial data on PostGIS, BigQuery, Snowflake, and Wherobots — enables spatial SQL analysis through an AI agent with real-time map visualization for previewing and validating geographic query results locally. Related: Claude_Code, AI, Data. Keywords: SQL, geospatial, spatial SQL, PostGIS, BigQuery, Snowflake, Claude Code, agents, skills