Is there something I just haven't found within Npgsql that would make it possible for me to get a parsed "tree" of a SQL statement using Npgsql? Something that breaks down the statement into its individual clauses (
ORDER BY, etc.) with the "sub-elements" (e.g., the actual column list from the
SELECT clause, or the specific conditions in the
WHERE clause) exposed as well?
I'd really like to be able to parse an existing statement, modify one or more clauses (add an
ORDER BY condition, alter the
WHERE condition, etc.), then have it recompiled for execution so that I don't have to either rebuild the statement entirely or do some "funky" RegEx or
String.Replace() calls to get the SQL I want in the end.
.rptdocument that I'm wanting to modify and push back into the document for the actual report generation. Like I said, I know I can do it manually, but I'd love to be able to do something like
WHEREClause.Add("column1" = "'value'")or
Microsoft.SqlServer.Management.SqlParser.dlllibrary, but that doesn't support PostgreSQL-specific syntax (e.g., string concatenation using