##! Please refer to the documentation at
##! https://coreruleset.org/docs/development/regex_assembly/.

##!+ i

##!> define required-spaces-plus-sql-function-call \s+\w+\(
##!> define quotes [\"'`]
##!> define start-comment \/\*!
##!> define lazy-optional-spaces \s*?
##!> define lazy-optional-spaces-with-numbers {{lazy-optional-spaces}}\d+{{lazy-optional-spaces}}
##!> define lazy-optional-spaces-numeric-function-call {{lazy-optional-spaces}}\({{lazy-optional-spaces}}\d
##!> define lazy-optional-spaces-plus-sql-function-call {{lazy-optional-spaces}}\w+\(

\){{lazy-optional-spaces}}when{{lazy-optional-spaces-with-numbers}}then

##!> assemble
  {{quotes}}{{lazy-optional-spaces}}
  ##!=>
  #
  --
  {
##!<

{{start-comment}}\s?\d+

##!> assemble
  \b
  ##!=>

  ##!> assemble
    binary
    char
    chr
    ##!=>
    {{lazy-optional-spaces-numeric-function-call}}
  ##!<

  ##!> assemble
    and
    nand
    or
    xor
    xxor
    div
    like
    between
    not
    regexp
    rlike
    ##!=>
    {{required-spaces-plus-sql-function-call}}
  ##!<
##!<

##!> assemble
  \|\|
  &&
  ##!=> 
  {{lazy-optional-spaces-plus-sql-function-call}}
##!<