Review By_Column in selectors and using Column within APIs

[wdanilo]

This task is automatically imported from the old Task Issue Board and it was originally created by James Dunkerley.
Original issue is here.

---

The current By_Column in selectors works by picking a matching name. This functionality should be removed.

When a column is passed to functions (such as Sum and Average) the column is only valid if in the table.
Derived columns would need to be set in the table.
Once expressions are supported they should be able to be used here.

[enso-bot]

James Dunkerley reports a new STANDUP for today (2023-02-09):

Progress: Worked through recreating the Colorado COVID example within a Cloud instance. Started removing last parts where Column allowed as an argument. Also restructuring Column_Selector. It should be finished by 2023-02-13.

Next Day: Work on Excel_Workbook and SQLite File_Format.

[jdunkerley]

Additionally: Add Vector_Editor attribute to Table.select_columns

[enso-bot]

James Dunkerley reports a new 🔴 DELAY for today (2023-02-13):

Summary: There is 2 days delay in implementation of the Review By_Column in selectors and using Column within APIs (#5153) task.
It will cause 0 day delay for the delivery of this weekly plan.

Delay Cause: Too much time on GH stuff. Took me a while to produce investor and iteration reports. Lots of stuff on plate.

[enso-bot]

James Dunkerley reports a new STANDUP for today (2023-02-13):

Progress: Tidying up the WIP I had. Investor summary, Iteration end. PR for Radek. It should be finished by 2023-02-17.

Next Day: Finish off the Column_Selector work.

[enso-bot]

James Dunkerley reports a new STANDUP for today (2023-02-14):

Progress: Preparing for demo on the MIMIC dataset. Backlog work for engines and libraries. Working on sorting out the Column_Selector rework. It should be finished by 2023-02-17.

Next Day: Get the Column_Selector merged and pushed out.

[enso-bot]

James Dunkerley reports a new STANDUP for today (2023-02-15):

Progress: Finished the Column_Selector work. Improved the Excel_Workbook to not reload over and over, It should be finished by 2023-02-17.

Next Day: Get PR merged and onto another issue.