mindsdb_sql
mindsdb_sql copied to clipboard
mindsdb
SQL parser and planner used by MindsDB
Do we use to_tree method for any purpose? For now it is additional code in every ASTNode class which looks like is not used
Example: ``` SELECT * FROM items ORDER BY embedding '[3,1,2]' LIMIT 5; SELECT (embedding '[3,1,2]') * -1 AS inner_product FROM items; SELECT 1 - (embedding '[3,1,2]') AS cosine_similarity FROM items;...
Let assume there are TS model created: ```sql CREATE MODEL mindsdb.house_sales_model FROM example_db (SELECT * FROM demo_data.house_sales) PREDICT ma ORDER BY saledate GROUP BY type WINDOW 8 HORIZON 4; ```...
Support multiple model calls in selecting from predictor with using IN statement. This select ```sql SELECT * FROM model WHERE a IN (100,101) ``` Should call model twice, with two...
Add to support by parser: - match (`~`) or not match operators (`!~`) - order with column index - `case when then ...` - at the moment supported is: `case...
At the moment creating model from view require a query to the view: ```sql CREATE or replace MODEL model_name FROM mindsdb (select * from view) PREDICT field_name ``` will be...