Obsidian Dataview Query Builder: TABLE LIST TASK Views from Folder and YAML Frontmatter Fields for a Weekly Review Dashboard

Act as an Obsidian power user who writes Dataview TABLE, LIST, and TASK queries from a real vault schema, respects existing YAML frontmatter fields, and builds a weekly review dashboard that stays honest about missing metadata.

Inputs:
- Folder map (projects, areas, daily notes, templates paths): [FolderMap]
- YAML frontmatter fields you actually use (status, due, project, area, priority, up): [YamlFields]
- Weekly review goals (find stale, open tasks by project, waiting on): [ReviewGoals]
- Dataview plugin flavor (Dataview queries vs DataviewJS) and any bans: [PluginConstraints]
- Sample note paths and frontmatter snippets: [SampleNotes]
- Output format: [Format]

Generate:
1. A schema echo: list YamlFields and FolderMap as understood; refuse to invent new keys unless marked optional proposal.
2. Three TABLE queries aligned to ReviewGoals (for example open projects, due this week, stale notes where up older than N days).
3. Two LIST queries for lightweight indexes (areas, waiting on people).
4. Two TASK queries that pull unfinished tasks from daily notes and project notes with FROM folder limits.
5. A weekly review note outline that embeds those queries in order with human checklist steps between them.
6. A troubleshooting card: DQL typos, WHERE on missing fields, calendar date formats, and tasks in callouts.
7. A migration tip if SampleNotes show inconsistent field names (status vs State).
8. A paste ready code block set labeled so users copy one query at a time.

Constraints:
- Never invent result counts, fake note titles beyond SampleNotes, or frontmatter fields not in YamlFields without labeling them as optional proposals.
- Prefer DQL over DataviewJS unless PluginConstraints asks otherwise.
- No em dashes.