prsqlite icon indicating copy to clipboard operation
prsqlite copied to clipboard

Parse Expr

Open kawasin73 opened this issue 1 year ago • 0 comments

https://www.sqlite.org/lang_expr.html

  • [ ] literal-value
    • [ ] numeric-literal #13
      • [x] integer
      • [x] float
      • [ ] Hexadecimal #14
    • [x] string-literal #16
    • [x] blob-literal #18
    • [x] NULL
    • [ ] TRUE
    • [ ] FALSE
    • [ ] CURRENT_TIME
    • [ ] CURRENT_DATE
    • [ ] CURRENT_TIMESTAMP
  • [ ] bind-parameter
  • [ ] column-name
    • [ ] schema.table.column
    • [ ] table.column
    • [x] column
  • [x] unary-operator: +[expr], -[expr], ~[expr]
  • [ ] binary-operator
    • [x] ||
    • [ ] ->, ->>
    • [ ] *, /, %
    • [ ] +, -
    • [ ] &, |, <<, >>
    • [x] <, >, <=, >=
    • [x] =, ==, <>, !=
    • [ ] AND
    • [ ] OR
  • [ ] function-name
  • [ ] multiple expr "([,])"
  • [x] cast #22
  • [x] collate #23
  • [ ] matching
    • [ ] like
    • [ ] glob
    • [ ] regexp
    • [ ] match
  • [ ] ISNULL, NOTNULL, NOT NULL
  • [ ] IS
  • [ ] BETWEEN
  • [ ] IN
  • [ ] select-stmt
  • [ ] CASE WHEN
  • [ ] raise-function

kawasin73 avatar Aug 06 '23 14:08 kawasin73