Is there a way to parse a T-SQL select statement with the M runtime?

Question

Searching around the Microsoft.M assembly I found the SourceParser class and whole set of classes in the Microsoft.TSQL10 namespace that seem related to parsing SQL but I cannot find examples of how to use it.

I know the you can generate T-SQL easily enough, but can you consume it, manipulate the data structure and re-output a modified version of the SQL select?

Thanks,

---

Darrel

Answer 1

Microsoft.M doesn't have SQL parsing capabilities, hence no samples for such. The code basically knows how to parse "M", and the TSQL10 classes you're looking at are only used for generating SQL text, not parsing it.

.Kraig

Answer 2

Thanks for the confirmation.

---

Darrel