mindsdb / mindsdb_sql

SQL parser and planner used by MindsDB
https://mindsdb.com
GNU General Public License v3.0
55 stars 21 forks source link

Mapping 'using' variables to model #351

Closed ea-rus closed 7 months ago

ea-rus commented 7 months ago

If we have different models in queries we may want to assign different variables to different models it that way

SELECT 
    t.column, 
    m2.prediction as pr2   
FROM table as t
    JOIN model1 as m1
    JOIN model2 as m2
USING m1.prompt_template = 'some template', m2.prompt_template='something else';