Roadmap v0.6

[Fedomn]

Redesign new Catalog, Binder, and Planner and then finish previous features:

• new planner & create table & insert table:
  • new catalog/binder/planner which supports create/insert table and simple select #96
  • support internal type conversion when insert table #98
  • support insert table null values #101
• select statement:
  • expand star expression when binding select node #103
  • support select expression alias #106
  • support select only expressions #108
  • support filter operation #120
  • support limit operator #133
  • support order operator #134
  • support count aggregation function #152
• other statements:
  • support COPY from statements #137
  • support create table as syntax #149
• pragma & table function:
  • support explain plan operator #110
  • introduce table function #115
  • support list all tables #113
  • describe table info #118
  • support read_csv table function #138
• function:
  • introduce scalar function and BoundFunctionExpression #121
  • introduce cast function and enhance scalar function binder with cast cost #123
  • introduce BoundConjunctionExpression #128
  • introduce BoundComparisonExpression #126
• others:
  • support different logging level #111
  • support idempotent for BoundCastExpression cast method #131
  • new logical type: Date & Interval #142

[caicancai]

He seems to be a cool thing, I can contribute well, I am a rust beginner, working in big data, interested in databases

[Fedomn]

He seems to be a cool thing, I can contribute well, I am a rust beginner, working in big data, interested in databases

Cool! This project is developing planner v2 that similar to duckdb. A few months ago i was migrating v1 functions but still left some operators.
If you're interested in this part, table function and scalar function are good first issues to start. Any questions can ping me on github.

[caicancai]

He seems to be a cool thing, I can contribute well, I am a rust beginner, working in big data, interested in databases

Cool! This project is developing planner v2 that similar to duckdb. A few months ago i was migrating v1 functions but still left some operators. If you're interested in this part, table function and scalar function are good first issues to start. Any questions can ping me on github.

Thank you for your reply. I am still learning rust. After the holidays, I will start to try to participate in this project.

[caicancai]

@Fedomn Hi, I've been learning rust for a while and I think I can start trying this part of the job, but I'm not very confident and it may take time. At present, I am also studying spark sql

[caicancai]

I would like to ask what is the future orientation or goal of this project.

[Fedomn]

I would like to ask what is the future orientation or goal of this project.

Sorry for the late reply, work has been too busy recently.
So, my current understanding this project is basically a playground for a query engine. You can try out fun ideas or experiment here, like subqueries and pipeline execution, because it's currently quite simple.
In the long term, I hope it could be a library that can be integrated into other programs, giving them efficient querying abilities.

[caicancai]

I would like to ask what is the future orientation or goal of this project.

Sorry for the late reply, work has been too busy recently. So, my current understanding this project is basically a playground for a query engine. You can try out fun ideas or experiment here, like subqueries and pipeline execution, because it's currently quite simple. In the long term, I hope it could be a library that can be integrated into other programs, giving them efficient querying abilities.

Thank you for your reply and I hope I can also contribute to this project