Generate a statement to insert values into temporary table.

Alias for the source table in a MERGE statement. Used when pretty printing MERGE statments.

Alias for the target table in a MERGE statement. Used when pretty printing MERGE statments.

USING section of a MERGE statement. Used in fromMerge.

ON section of a MERGE statement. Used in fromMerge.

WHEN MATCHED section of a MERGE statement. Used in fromMerge.

WHEN NOT MATCHED section of a MERGE statement. Used in fromMerge.

Generate a MERGE SQL statement

Generate a delete statement

Delete
  (Aliased (TableName "table" "schema") "alias")
  [ColumnName "id", ColumnName "name"]
  (Where [OpExpression EQ' (ValueExpression (IntValue 1)) (ValueExpression (IntValue 1))])

Becomes:

DELETE [alias] OUTPUT DELETED.[id], DELETED.[name] INTO #deleted([id], [name]) FROM [schema].[table] AS [alias] WHERE ((1) = (1))

Generate an update statement

Update
   (Aliased (TableName "table" "schema") "alias")
   (fromList [(ColumnName "name", ValueExpression (TextValue "updated_name"))])
   (Output Inserted)
   (TempTable (TempTableName "updated") [ColumnName "id", ColumnName "name"])
   (Where [OpExpression EQ' (ColumnName "id") (ValueExpression (IntValue 1))])

Becomes:

UPDATE [alias] SET [alias].[name] = 'updated_name' OUTPUT INSERTED.[id], INSERTED.[name] INTO
#updated([id], [name]) FROM [schema].[table] AS [alias] WHERE (id = 1)

Converts SelectIntoTempTable.

SelectIntoTempTable (TempTableName "deleted")  [UnifiedColumn "id" IntegerType, UnifiedColumn "name" TextType] (TableName "table" "schema")

Becomes:

SELECT [id], [name] INTO #deleted([id], [name]) FROM [schema].[table] WHERE (1<>1) UNION ALL SELECT [id], [name] FROM [schema].[table];

We add the `UNION ALL` part to avoid copying identity constraints, and we cast columns with types such as timestamp which are non-insertable to a different type.

TempTableName "deleted" becomes #deleted

@TempTableName "temp_table" is converted to "DROP TABLE #temp_table"

Drop useless examples like this from the output:

WHERE (((1<>1)) AND ((1=1))) AND ((1=1))

And

WHERE ((1<>1))

They're redundant, but make the output less readable.

Pretty-prints a Printer as one line, converting NewlinePrinter to space.

Pretty-prints a Printer as multiple lines as defined by the printer.