posit-dev / posit-dev/orbital

Allow ResultsProjection to rename columns

Open
#69 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

good first issue
Dominant language
Python
Stars
120
Forks
9
Avg merge
11d 6m
Merged PRs (30d)
2

Description

ResultsProjection currently allows to pick which variables should be exposed in the SQL results, but the names cannot be picked by the user. It would be convenient to allow the user to choose those names, and that can be easily implemented by supporting renaming columns in ResultsProjection.

See the original feedback:

Variable names: orbital notes for input variables that . has a different semantic meaning in SQL so changes . to _. It would be nice to automatically do this for the output also (e.g. output_probability_0) or even to allow for custom names (in the case where one is ultimately tracking multiple models)

It has to be noted that the purpose of Orbital is now to implement a full query language, so for more complex cases than just renaming it just makes sense to push users toward using translate and then apply any further Ibis transformation they want instead of directly using export_sql

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 at the ResultsProjection implementation and trace how translate and export_sql produce output column names. Define completion as allowing users to choose result-column names while preserving the existing selection behavior and leaving more complex transformations to translate and Ibis.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sql
Domain
backend-api-design, databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.