C# - SQL WITH clause

Question

只是在寻找灵感-

我有一个SQL语句，我需要在c#解析。它的格式基本如下-

    WITH TableX as (
    -- something else could be here..
    select field1, field2, .. fieldX
    from mytable
    -- something else could be here..
    )
    -- something else could be here..
    select /*THESE FIELDS ARE BEING REPLACED*/ TableX.field1, TableX.field2, .. TableX.fieldX
    from TableX
    -- something else could be here.. ie, more joins, selecting from subqueries. Basically another select could exist here.

关于如何替换"TableX."field1 TableX。field2, . .TableX。fieldX"与另一组字段保证在结果集中?

Answer 1

您可以使用一个完整的SQL解析器来构建一个解析树，然后从那里有选择地替换条目。

非平凡的任务。