/chronicle standup returns no results when local sessions exist (SQLite INTERVAL syntax not supported)

[FMC-Mauro]

Describe the bug

The /chronicle standup command returns empty results even when many local sessions exist. The standup prompt queries the session store using now() - INTERVAL '1 day', which is DuckDB syntax. The local session store uses SQLite, which does not support INTERVAL syntax and silently drops the query — returning 0 rows instead of an error.

Affected version

GitHub Copilot CLI 1.0.61

Steps to reproduce the behavior

1. Have local sessions stored (i.e. have used the CLI previously in local mode)
2. Run /chronicle standup in a new chat
3. Observe that the standup reports no sessions found, despite local sessions existing

Expected behavior

The standup should find and report sessions from the local store from the past 24 hours. Using a literal ISO timestamp (WHERE updated_at >= '2026-06-11T06:00:00Z') instead of INTERVAL syntax correctly retrieves local sessions from the same store, confirming the data is there.

Additional context

• OS: Windows 11
• The session_store_sql tool description states "Local results are best-effort and may be omitted if the query uses DuckDB-only syntax unsupported by SQLite" — the standup prompt consistently uses DuckDB-only syntax, making it systematically broken for local-only users.
• Workaround: manually querying with a hardcoded timestamp retrieves results correctly.