Implement additional Filter Formula methods into query builder.

[GV14982]

We are currently missing a large portion of the methods within Airtable's filter formulas. Some that would take priority are:

• All of Array methods
• String methods
  • SEARCH
  • FIND

I will keep this issue open until we have 100% coverage of the filter formula spec within the query builder. I can write some tests and a tracker to handle it as well:

• [ ] Text operators
  • [ ] &
• [x] Text functions
  • [x] ARRAYJOIN([item1, item2, item3], separator)
  • [x] CONCATENATE(text1, [text2, ...])
  • [x] ENCODE_URL_COMPONENT(component_string)
  • [x] FIND(stringToFind, whereToSearch,[startFromPosition])
  • [x] LEFT(string, howMany)
  • [x] LEN(string)
  • [ ] LOWER(string)
  • [ ] MID(string, whereToStart, count)
  • [ ] REPLACE(string, start_character, number_of_characters, replacement)
  • [ ] REPT(string, number)
  • [ ] RIGHT(string, howMany)
  • [x] SEARCH(stringToFind, whereToSearch,[startFromPosition])
  • [ ] SUBSTITUTE(string, old_text, new_text, [index])
  • [ ] T(value1)
  • [ ] TRIM(string)
  • [ ] UPPER(string)
• [x] Logical operators
  • [x] >
  • [x] <
  • [x] >=
  • [x] <=
  • [x] =
  • [x] !=
• [ ] Logical functions
  • [x] AND(logical1, [logical2, ...])
  • [x] BLANK()
  • [ ] ERROR()
  • [x] FALSE()
  • [x] IF(logical, value1, value2)
  • [ ] ISERROR(expr)
  • [x] NOT(boolean)
  • [x] OR(logical1, [logical2, ...])
  • [ ] SWITCH(expression, [pattern, result ... , default])
  • [x] TRUE()
  • [ ] XOR(logical1, [logical2, ...])
• [ ] Numeric operators
  • [ ] -
  • [ ] -
  • [ ] *
  • [ ] /
• [ ] Numeric functions
  • [ ] ABS(value)
  • [ ] AVERAGE(number1, [number2, ...])
  • [ ] CEILING(value, [significance])
  • [ ] COUNT(number1, [number2, ....])
  • [ ] COUNTA(textOrNumber1, [number2, ....])
  • [ ] COUNTALL(textOrNumber1, [number2, ....])
  • [ ] EVEN(value)
  • [ ] EXP(power)
  • [ ] FLOOR(value, [significance])
  • [ ] INT(value)
  • [ ] LOG(number, [base])
  • [ ] MAX(number1, [number2, ...])
  • [ ] MIN(number1, [number2, ...])
  • [ ] MOD(value1, divisor)
  • [ ] ODD(value)
  • [ ] POWER(base, power)
  • [ ] ROUND(value, precision)
  • [ ] ROUNDDOWN(value, precision)
  • [ ] ROUNDUP(value, precision)
  • [ ] SQRT(value)
  • [ ] SUM(number1, [number2, ...])
  • [ ] VALUE(text)
• [ ] Date and Time Functions
  • [ ] CREATED_TIME()
  • [ ] DATEADD([date], [#], 'units')
  • [ ] DATESTR([date])
  • [ ] DATETIME_DIFF([date1], [date2], 'units')
  • [ ] DATETIME_FORMAT([date], '[specified output format]')
  • [ ] DATETIME_PARSE(date, ['input format'], ['locale'])
  • [ ] DAY([date])
  • [ ] HOUR([datetime])
  • [ ] IS_AFTER([date1], [date2])
  • [ ] IS_BEFORE([date1], [date2])
  • [ ] IS_SAME([date1], [date2], [unit])
  • [ ] LAST_MODIFIED_TIME([{field1},{field2}, ...])
  • [ ] MINUTE([datetime])
  • [ ] MONTH([date])
  • [ ] NOW()
  • [ ] SECOND([datetime])
  • [ ] SET_LOCALE([date], [locale_modifier])
  • [ ] SET_TIMEZONE([date], [tz_identifier])
  • [ ] TIMESTR([date/timestamp])
  • [ ] TONOW([date]), FROMNOW([date])
  • [ ] TODAY()
  • [ ] WEEKDAY(date, [startDayOfWeek])
  • [ ] WEEKNUM(date, [startDayOfWeek])
  • [ ] WORKDAY(startDate, numDays, [holidays])
  • [ ] WORKDAY_DIFF(startDate, endDate, [holidays])
  • [ ] YEAR([date])
• [x] Array functions
  • [x] ARRAYCOMPACT(values)
  • [x] ARRAYFLATTEN(values)
  • [x] ARRAYJOIN(values, separator)
  • [x] ARRAYUNIQUE(values)
• [ ] Record functions
  • [ ] CREATED_TIME()
  • [ ] RECORD_ID()
• [ ] REGEX functions
  • [ ] REGEX_MATCH(string, regex)
  • [ ] REGEX_EXTRACT(string, regex)
  • [ ] REGEX_REPLACE(string, regex, replacement)

Reference #52 as the prioritized methods are required for what they are asking for.