001package gudusoft.gsqlparser;
002
003/**
004 * Vendor-neutral enum for SQL pseudo table qualifiers used in DML OUTPUT/RETURNING clauses
005 * and trigger bodies.
006 * <p>
007 * SQL Server: INSERTED/DELETED in OUTPUT clauses and triggers
008 * Oracle/PostgreSQL/MySQL: OLD/NEW in trigger bodies
009 * <p>
010 * Example (SQL Server):
011 * <pre>
012 * UPDATE t SET col = val
013 * OUTPUT inserted.col, deleted.col INTO @changes;
014 * </pre>
015 */
016public enum EPseudoTableType {
017    /** No pseudo table qualifier */
018    none,
019    /** SQL Server INSERTED pseudo table (post-change values) */
020    inserted,
021    /** SQL Server DELETED pseudo table (pre-change values) */
022    deleted,
023    /** Oracle/PostgreSQL OLD pseudo table (pre-change values) */
024    old_value,
025    /** Oracle/PostgreSQL NEW pseudo table (post-change values) */
026    new_value
027}