Some Useful User Defined Functions

[ismaen]

Courtesy of @kyung.

Arrays#Append

FLAT([ array, [ element ] ])[?(@ <> NULL)]

Arrays#Combine

FLAT([ array, array_2 ])[?(@ <> NULL)]

Arrays#IsValid

LENGTH(array[?(ISNOTEMPTY(@))]) = LENGTH(array)
  AND LENGTH(array[?(ISNOTEMPTY(@))]) > 0

Arrays#DeleteItem

FROM
  p,
  idx
IN
  array
WHERE
  NOT(
    index = idx
  )
SELECT
  p

Objects#Set (Edited per comments)

MERGE_OBJECTS(
  [ obj, { "{{key}}": value } ]
)

Objects#Remove

FROM
  p
IN
  KEYS(
    obj
  )
WHERE
  NOT(
    CONTAINS(
      FLAT(
        [ keys ]
      ),
      p
    )
  )
SELECT
  "{{p}}": obj[p]

[ian]

as usual. These are really useful!

[ackerman]

Thank you for these!!

[kyung]

One note, Object#Set needs a minor change:

MERGE_OBJECTS(
  [ obj, { "{{key}}": value } ]
)

Ran into an issue when testing it.