IN> table.name AS table_name, table.id, CASE table.type WHEN 'l' THEN 'locked' WHEN 'u' THEN 'unlocked' ELSE NULL END, table.age BETWEEN NOW() - INTERVAL 1
DAY AND NOW() + INTERVAL 1 DAY⏎
OUT> [
OUT> "select",
OUT> undef,
OUT> [
OUT> [
OUT> "alias",
OUT> "table_name",
OUT> [
OUT> "ident",
OUT> "table",
OUT> "name",
OUT> ],
OUT> ],
OUT> [
OUT> "ident",
OUT> "table",
OUT> "id",
OUT> ],
OUT> [
OUT> "case",
OUT> [
OUT> "ident",
OUT> "table",
OUT> "type",
OUT> ],
OUT> [
OUT> [
OUT> "when",
OUT> [
OUT> "quote",
OUT> "l",
OUT> ],
OUT> [
OUT> "quote",
OUT> "locked",
OUT> ],
OUT> ],
OUT> [
OUT> "when",
OUT> [
OUT> "quote",
OUT> "u",
OUT> ],
OUT> [
OUT> "quote",
OUT> "unlocked",
OUT> ],
OUT> ],
OUT> [
OUT> "else",
OUT> [
OUT> "const",
OUT> "NULL",
OUT> ],
OUT> ],
OUT> ],
OUT> ],
OUT> [
OUT> "between",
OUT> [
OUT> "ident",
OUT> "table",
OUT> "age",
OUT> ],
OUT> [
OUT> "binop",
OUT> "-",
OUT> [
OUT> "call",
OUT> "NOW",
OUT> [],
OUT> ],
OUT> [
OUT> "interval",
OUT> 1,
OUT> "DAY",
OUT> ],
OUT> ],
OUT> [
OUT> "binop",
OUT> "+",
OUT> [
OUT> "call",
OUT> "NOW",
OUT> [],
OUT> ],
OUT> [
OUT> "interval",
OUT> 1,
OUT> "DAY",
OUT> ],
OUT> ],
OUT> ],
OUT> ],
OUT> ]
OUT>
OUT> `table`.`name` AS `table_name`, `table`.`id`, CASE `table`.`type` WHEN 'l' THEN 'locked' WHEN 'u' THEN 'unlocked' ELSE NULL END, `table`.`age` BETWEEN NOW() - INTERVAL 1 DAY AND NOW() + INTERVAL 1 DAY
Last active
February 9, 2020 23:23
-
-
Save dylanwh/21637ae61d28604e06c5b352319d2a5e to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment