Draft inspectable queries before answering data questions

Plan SQL from fictional fields and sample rows, separating drafts, manual checks and results not yet executed.

適用情境 / When to use

Cognition reports warehouse answers with inspectable SQL from DANA. This adaptation drafts text only and connects to no database.

步驟 / Steps

1. Open an ordinary text chat at gemini.google.com with an eligible account. Prepare shareable or fictional plain text using the prompt parameters; transcribe it yourself and mark ambiguities. Do not upload source files or connect accounts.
2. Paste the text and prompt; request only a draft, comparison or plan, not tool execution.
3. Check every output against supplied sources, references and unknowns. A human decides next steps; no automatic publishing, payment or deployment.

提示詞 / Prompt

Using only [fictional tables, field definitions and sample rows], draft a read-only SELECT query for [question, metric definitions, period, timezone and SQL dialect]. List missing inputs before proceeding; guess no fields or relationships. Explain joins, filters, denominators, nulls and duplicate keys, with expected sample reasoning for human checking. Mark unexecuted queries as unexecuted; invent no results or performance claims. Separate query drafts from manual reasoning. Do not connect to databases, run code, read credentials, write or share data. A qualified person must validate in an isolated test copy first.

留意事項 / Cautions

• Vendor reporting is not independent accuracy evidence. We ran no SQL; drafts may contain syntax or logic errors.
• Checked 2026-11-01: official Gemini web lists Hong Kong, Macau, Taiwan, Traditional/Simplified Chinese and English; account and age eligibility apply. Limited use is available without a paid AI plan and varies by account and workload. Taiwan’s public subscription page lists Free at NT$0/month; no paid plan is required for this exercise. HK/Macau paid prices and local taxes, offers and final quotes are unverified. Output quality in all three languages is untested. Web eligibility does not establish App/API eligibility; neither is needed here. Original-tool regional features, devices and paid eligibility are unconfirmed; do not bypass restrictions. Android’s official region list also includes HK/Macau/Taiwan. The iOS and AI Studio/Gemini API lists include Taiwan, not Hong Kong or Macau; feature and device restrictions still apply.

來源限制 / Evidence limits

Vendor reporting is not independent accuracy evidence. We ran no SQL; drafts may contain syntax or logic errors.

流程說明 / Workflow note

Original, untested text-only exercise by this site; it does not reproduce source devices, agents or integrations. Checked 2026-11-01: official Gemini web lists Hong Kong, Macau, Taiwan, Traditional/Simplified Chinese and English; account and age eligibility apply. Limited use is available without a paid AI plan and varies by account and workload. Taiwan’s public subscription page lists Free at NT$0/month; no paid plan is required for this exercise. HK/Macau paid prices and local taxes, offers and final quotes are unverified. Output quality in all three languages is untested. Web eligibility does not establish App/API eligibility; neither is needed here. Original-tool regional features, devices and paid eligibility are unconfirmed; do not bypass restrictions. Android’s official region list also includes HK/Macau/Taiwan. The iOS and AI Studio/Gemini API lists include Taiwan, not Hong Kong or Macau; feature and device restrictions still apply.

原始工具組合 / Original tool stack

Devin / DANA; warehouse MCP; Slack; seaborn

Source publication date: 2026-02-27

Source checked: 2026-11-01

How Cognition Uses Devin to Build Devin