Feature Request: Collapsible Query Details Section

[laresbernardo]

Summary

Add an option to make the Query Data section (SQL query and results) collapsible by default, showing only the AI's natural language answer with a toggle to expand/collapse the technical details.

Problem Statement

Currently, when users interact with querychat, the query details (generated SQL and raw results) are always visible and expanded. For end users who primarily care about the AI's answer rather than the technical implementation, this creates visual clutter and makes the interface less user-friendly.

Current Behavior

When a user submits a query:

• The generated SQL query is displayed
• The raw query results are displayed
• The AI's natural language answer is displayed below

All sections are visible simultaneously, requiring users to scroll through technical details even when they only need the answer.

Desired Behavior

Provide an option or parameter to set the default to collapsed, showing only the AI answer, with query details collapsed.

Proposed API

querychat_init(
  data_source = my_data,
  collapse_query = TRUE,  # New parameter
  # ...other parameters
)

[gadenbuie]

Thanks for the feature request! I agree this would improve the user experience, especially when the user isn't as interested in the exact SQL code.

I'd like to solve this with an R option and environment variable that controls the default state of tool detail cards:

Option name: querychat.tool_details
Environment variable: QUERYCHAT_TOOL_DETAILS

Values:

• "expanded" - Tool cards are always shown expanded
• "collapsed" - Tool cards are always shown collapsed (solves your use case)
• "default" - Uses tool-specific behavior (some expanded, some collapsed based on tool type) — this is the behavior when unset

Usage:

# Set for the session
options(querychat.tool_details = "collapsed")

# Or set via environment variable in .Renviron
QUERYCHAT_TOOL_DETAILS=collapsed

This approach gives the needed control while maintaining flexibility. The naming also leaves room for future enhancements (like potentially hiding tool cards entirely with a "hidden" option).