I work as a Data Engineer, spending most of my day writing BigQuery SQL for large-scale GCP migrations. One thing kept annoying me: I'd constantly forget the exact syntax for things like UNNEST, window functions, or MERGE statements, and end up re-Googling the same StackOverflow answers over and over.
So I decided to fix it myself, and use it as an excuse to try Google Antigravity, the new agentic development platform Google launched this year.
What is Antigravity, anyway?
Unlike a typical AI code editor where you write code and the AI autocompletes it, Antigravity flips the model. You describe the task, and an agent plans, writes, tests, and iterates on the code largely on its own, across your editor, terminal, and even the browser.
I wanted to see how far I could get without writing code by hand.
The Build
I gave it a simple starting prompt: build an interactive, offline-first BigQuery SQL cheatsheet — searchable, with copy-to-clipboard buttons, categorized by topic, with a dark/light theme toggle.
A few iterations later, I had:
- 25+ categorized SQL snippets (Arrays, Structs, Window Functions, JSON, DDL/DML, performance tips)
- Live fuzzy search across titles, tags, and syntax
- One-click copy on every snippet
- A glassmorphic dark/light UI
- Zero backend — just a single HTML/CSS/JS bundle that runs fully offline
No frameworks, no build step. Just open
index.htmlin a browser.
What Surprised Me
The agent handled the boring-but-tedious parts well: organizing snippets into clean categories, building the search/filter logic, and getting the UI polish right (rounded cards, smooth transitions, responsive layout). I mostly nudged it on content accuracy and structure rather than writing CSS by hand.
It's not magic — I still had to review the SQL examples for correctness since BigQuery has a lot of edge cases around cost optimization. But for scaffolding an entire interactive tool in an afternoon, it was a genuinely different workflow than the "write code, ask AI to fix it" loop I'm used to.
Try It
I packaged the final result and put it up for anyone who wants it: BigQuery SQL Interactive Cheatsheet
It's pay-what-you-want. If you work with BigQuery regularly, or you're studying for a GCP Data Engineer interview, it might save you a few StackOverflow trips.
Curious if other data engineers have tried agent-first tools like Antigravity for non-trivial builds — would love to hear what worked (or didn't) for you.
Top comments (0)