posit-dev / posit-dev/querychat

Let querychat display a subset of the table's columns

Open
#270 0 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Python
Stars
212
Forks
29
Avg merge
22h 24m
Merged PRs (30d)
27

Description

In the prompt.md, it says:

The query MUST return all columns from the specified table's schema (you can use SELECT *)

If we are touching a database for instance with 100+ columns, the table can be a bit unwieldly. Is it possible to modify it so that it only returns the columns necessary for the natural language query if requested by the user?

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reading prompt.md, especially the instruction requiring all columns from the specified table's schema. Trace how this instruction is used for query generation and determine how a user's request for a subset should be represented. Done means a natural-language request can produce a query returning only the necessary columns when requested, without changing the existing behavior otherwise.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
data, database
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
65/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.