I'm trying to locate the documentation for the SQL datasource so I can learn how to use it. I feel like I'm missing something obvious.

Questions I'm trying to get answered:

  • Does the SQL data source support insert statements? The field header would imply it only supports select statements.

  • If I am able to use insert statements, can I insert the value of other tags, or just static values typed directly into the query?

  • If I am able to use tags as part of an insert query, do I use the XiD of the tag, or the name of the tag in the query?

Some examples might help. I feel like there is a piece of documentation that would explain all of this, but I can't seem to find it. I click on documentation on the website and it leads me to a video explaining the datasource menu item, but not information about the specific data source types.

Any help would be appreciated,