sqlrs
sqlrs copied to clipboard
Fedomn
sqlrs is an in-process sql query engine
Scalar subqueries are subqueries that return a single result. Scalar subqueries can either be correlated or uncorrelated. ## Uncorrelated Scalar Subqueries An uncorrelated subquery returns the **same single value** for...
Introduce distinct and subquery: ```sql -- distinct select distinct state from employee; select count(distinct(b)) from t2; -- alias select a as c1 from t1 order by c1 desc limit 1;...
We already have a simple aggregation implementation in V1 https://github.com/Fedomn/sqlrs/blob/main/src/executor/aggregate/simple_agg.rs, that could be a reference. A different point is that this function need migrate into V2 planner, that could refer...
Redesign new Catalog, Binder, and Planner and then finish previous features: - new planner & create table & insert table: - [x] #96 - [x] #98 - [x] #101 -...
using https://docs.rs/snafu/latest/snafu/ maybe refer: [OpenDAL's Error Handling Practices ](https://xuanwo.io/reports/2022-46/https://xuanwo.io/reports/2022-46/)
new scalar function `alias(col1)` to output column alias name. such as: ```sql SELECT alias(i % 2) AS p, alias(SUM(i)) AS sum_i FROM integers GROUP BY p ORDER BY 1 ----...
see [Timestamp](https://arrow.apache.org/docs/cpp/api/datatype.html#_CPPv4N5arrow4Type4type9TIMESTAMPE)
refer to https://duckdb.org/docs/data/parquet.html