Limitations

    Column based shadow algorithm

    condition categoriesSQLsupport or not
    =SELECT/UPDATE/DELETE … WHERE column = valuesupport
    LIKE/NOT LIKESELECT/UPDATE/DELETE … WHERE column LIKE/NOT LIKE valuesupport
    IN/NOT INSELECT/UPDATE/DELETE … WHERE column IN/NOT IN (value1,value2,…)support
    BETWEENSELECT/UPDATE/DELETE … WHERE column BETWEEN value1 AND value2do not support
    GROUP BY … HAVING…SELECT/UPDATE/DELETE … WHERE … GROUP BY column HAVING column > valuedo not support
    Sub QuerySELECT/UPDATE/DELETE … WHERE column = (SELECT column FROM table WHERE column = value)do not support