add(SQLOps.ALL, "{0}.*"); add(SQLOps.WITH_ALIAS, "{0} as {1}", 0); add(SQLOps.WITH_COLUMNS, "{0} {1}", 0); add(SQLOps.FOR_UPDATE, "\nfor update"); add(SQLOps.FOR_SHARE, "\nfor share"); add(SQLOps.NO_WAIT, " nowait"); add(SQLOps.QUALIFY, "\nqualify {0}"); add(Ops.AND, "{0} and {1}"); add(Ops.NOT, "not {0}", Precedence.NOT); add(Ops.OR, "{0} or {1}"); add(Ops.MathOps.RANDOM, "rand()"); add(Ops.MathOps.RANDOM2, "rand({0})"); add(Ops.MathOps.CEIL, "ceiling({0})"); add(Ops.MathOps.POWER, "power({0},{1})"); add(Ops.MOD, "mod({0},{1})", Precedence.HIGHEST); add(Ops.DateTimeOps.CURRENT_DATE, "current_date"); add(Ops.DateTimeOps.CURRENT_TIME, "current_time"); add(Ops.DateTimeOps.CURRENT_TIMESTAMP, "current_timestamp"); add(Ops.DateTimeOps.MILLISECOND, "0"); add(Ops.DateTimeOps.SECOND, "extract(second from {0})"); add(Ops.DateTimeOps.MINUTE, "extract(minute from {0})"); add(Ops.DateTimeOps.HOUR, "extract(hour from {0})"); add(Ops.DateTimeOps.WEEK, "extract(week from {0})"); add(Ops.DateTimeOps.MONTH, "extract(month from {0})");