texera icon indicating copy to clipboard operation
texera copied to clipboard

SQL Operator with real SQL

Open Yicong-Huang opened this issue 3 years ago • 1 comments

A general SQL Operator which lets user to write SQL query directly, this way it is more flexible to express the need. This feature can be combined with PreSet to replace existing SQL operators.

One thing to investigate is how to obtain the schema before executing the SQL query. There are two ways:

  1. DB/JDBC might have API to query for the schema with a given SQL query.
  2. some SQL compiler like calcite to compile schema out from SQL query.

Yicong-Huang avatar Jan 15 '22 01:01 Yicong-Huang

Discussion 2022.05.19: low priority

zuozhiw avatar May 19 '22 19:05 zuozhiw

Discussion 2022.05.12: Low priority.

Xiao-zhen-Liu avatar Dec 08 '22 00:12 Xiao-zhen-Liu