EmbeddedSQLExpression

EmbeddedSQLExpression[string]

represents an SQL expression to be evaluated verbatim within an EntityFunction object.

EmbeddedSQLExpression[template,args]

represents an SQL expression string template with arguments provided by args.

Details

Examples

Basic Examples  (1)

Register a RelationalDatabase-backed EntityStore:

EmbeddedSQLExpression can be used to evaluate any SQL expression:

Use the second argument to bind literal values:

Bind compilable expressions:

Bind properties of the outer query:

Bind a subquery (possibly correlated):

Wolfram Research (2020), EmbeddedSQLExpression, Wolfram Language function, https://reference.wolfram.com/language/ref/EmbeddedSQLExpression.html.

Text

Wolfram Research (2020), EmbeddedSQLExpression, Wolfram Language function, https://reference.wolfram.com/language/ref/EmbeddedSQLExpression.html.

BibTeX

@misc{reference.wolfram_2021_embeddedsqlexpression, author="Wolfram Research", title="{EmbeddedSQLExpression}", year="2020", howpublished="\url{https://reference.wolfram.com/language/ref/EmbeddedSQLExpression.html}", note=[Accessed: 27-November-2021 ]}

BibLaTeX

@online{reference.wolfram_2021_embeddedsqlexpression, organization={Wolfram Research}, title={EmbeddedSQLExpression}, year={2020}, url={https://reference.wolfram.com/language/ref/EmbeddedSQLExpression.html}, note=[Accessed: 27-November-2021 ]}

CMS

Wolfram Language. 2020. "EmbeddedSQLExpression." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/ref/EmbeddedSQLExpression.html.

APA

Wolfram Language. (2020). EmbeddedSQLExpression. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/EmbeddedSQLExpression.html