Combining Commands
SQL-inf supports combining SQL-inf commands through chaining.
For example, to use EXPLAIN
you need to chain it with another command.
SELECT * FROM customers EXPLAIN(PREDICT(churn))
You can also chain several commands together through nesting of SQL-statements.
In this example we nest a SENTIMENT
statement within an EXPLAIN-PREDICT
statement to allow us to explain the inner command, ie the output of the SENTIMENT
.
SELECT * FROM (SELECT * FROM customer_feedback SENTIMENT("Review Text")) EXPLAIN(PREDICT(prediction))