Property reference

glide.db.passthrough.func.allowlist_default

The glide.db.passthrough.func.allowlist_default property specifies a default list of SQL functions that are permitted for passthrough execution. Administrators should review this property to ensure that only necessary functions are allowed, enhancing security and performance.

Default
ABS,ACOS,ADDDATE,ADDTIME,AGE,ANY,ARRAY_AGG,ARRAY_CAT,ARRAY_DIM,ARRAY_FILL,ARRAY_LENGTH,ARRAY_LOWER,ARRAY_NDIMS,ARRAY_PREPEND,ARRAY_TO_JSON,ARRAY_TO_STRING,ARRAY_UPPER,ASCII,ASIN,ASYMKEY_ID,ATAN,ATAN2,AVG,BIN,BINBINARY,BIT_AND,BIT_COUNT,BIT_LENGTH,BIT_OR,BIT_XOR,BOOL_AND,BOOL_OR,BTRIM,CAST,CBOOL,CBRT,CBYTE,CCUR,CDATE,CDBL,CEIL,CEILING,CHANGES,CHAR,CHARACTER_LENGTH,CHARINDEX,CHARSET,CHAR_LENGTH,CHECKSUM_AGG,CHOOSE,CHR,CINT,CLNG,CLOCK_TIMESTAMP,COALESCE,COL_LENGTH,COL_NAME,COMPRESS,CONCAT,CONCAT_WS,CONV,CONVERT,CONVERT_FROM,CONVERT_TO,CONVERT_TZ,COS,COT,COUNT,CRC32,CSNG,CUME_DIST,CURDATE,CURRENT_QUERY,CURRVAL,CURSOR_STATUS,CURTIME,CVAR,DATALENGTH,DATE,DATEADD,DATEDIFF,DATEFROMPARTS,DATENAME,DATEPART,DATESERIAL,DATETIME2FROMPARTS,DATETIMEFROMPARTS,DATETIMEOFFSETFROMPARTS,DATEVALUE,DATE_ADD,DATE_FORMAT,DATE_PART,DATE_SUB,DATE_TRUNC,DAVG,DAY,DAYNAME,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR,DCOUNT,DECODE,DEGREES,DENSE_RANK,DFIRST,DIFFERENCE,DLAST,DLOOKUP,DMAX,DMIN,DOTWALK,DSUM,DURATION_BETWEEN,DURATION_IN_DAYS,DURATION_IN_MONTHS,DURATION_IN_SECONDS,DV,ELT,ENCODE,ENUM_FIRST,ENUM_LAST,ENUM_RANGE,EOMONTH,EVENTDATA,EXISTS,EXP,EXTRACT,EXTRACTVALUE,EXTRACT_VALUE,FIELD,FIND_IN_SET,FIRST_VALUE,FLOOR,FORMAT,FOUND_ROWS,FROM_BASE64,FROM_DAYS,FROM_UNIXTIME,GETATTR,GETDATE,GETUTCDATE,GET_BIT,GET_BYTE,GET_FORMAT,GET_LOCK,GLIDE_CAST,GLIDE_DATE_TRUNC,GREATEST,GROUPING,GROUPING_ID,GROUP_CONCAT,HASHBYTES,HEX,HOUR,IF,IF EXISTS,IF NOT,IF NOT EXISTS,IFF,IFNULL,IIF,INDEXKEY_PROPERTY,INDEXPROPERTY,INDEX_COL,INET_ATON,INET_NTOA,INITCAP,INSTR,INSTRREV,ISDATE,ISEMPTY,ISFINITE,ISNULL,ISNUMERIC,IS_FREE_LOCK,IS_MEMBER,IS_OBJECTSIGNED,IS_ROLEMEMBER,IS_SRVROLEMEMBER,IS_USED_LOCK,JSON_KEYS,JULIANDAY,JUSTIFY_DAYS,JUSTIFY_HOURS,JUSTIFY_INTERVAL,KEY_GUID,KEY_ID,LAG,LASTVAL,LAST_INSERT_ID,LAST_INSERT_ROWID,LAST_VALUE,LCASE,LEAD,LEAST,LENGTH,LN,LOCATE,LOG,LOG10,LOWER,LOWER_INC,LOWER_INF,LPAD,LTRIM,MAKEDATE,MAKE_SET,MASKLEN,MASTER_POS_WAIT,MAX,MD5,MICROSECOND,MID,MIN,MINUTE,MKDIR,MOD,MONTH,MONTHNAME,NAME_CONST,NETMASK,NEXTVAL,NOW,NTH_VALUE,NTILE,NULLIF,NZ,OCT,OCTET_LENGTH,OPENQUERY,OPENROWSET,OPENXML,ORD,OVERLAPS,OVERLAY,PERCENTILE_COUNT,PERCENTILE_DISC,PERCENTILE_RANK,PERCENT_RANK,PERIOD_ADD,PERIOD_DIFF,PI,POSITION,POW,POWER,QUARTER,QUOTE,QUOTENAME,QUOTE_IDENT,QUOTE_LITERAL,QUOTE_NULLABLE,RADIANS,RAND,RANDOM,RANDOMBLOB,RANK,REGEXP_INSTR,REGEXP_MATCHES,REGEXP_REPLACE,REGEXP_SPLIT_TO_ARRAY,REGEXP_SPLIT_TO_TABLE,REGEXP_SUBSTR,RELEASE_LOCK,REPEAT,REPLACE,REVERSE,ROUND,ROW,ROW_COUNT,ROW_NUMBER,ROW_TO_JSON,RPAD,RTRIM,SECOND,SEC_TO_TIME,SETATTR,SETSEED,SETVAL,SET_BIT,SET_BYTE,SET_MASKLEN,SHA,SHA1,SHA2,SIGN,SIN,SMALLDATETIMEFROMPARTS,SOME,SPACE,SPLIT_PART,SQRT,STATEMENT_TIMESTAMP,STATS_DATE,STDDEV,STDDEV_POP,STDDEV_SAMP,STRCMP,STRCOMP,STRCONV,STRING_AGG,STRING_TO_ARRAY,STRPOS,STR_TO_DATE,STUFF,SUBDATE,SUBSTR,SUBSTRING,SUBSTRING_INDEX,SUBTIME,SUM,SWITCHOFFET,SYS.STRAGG,SYSDATE,SYSDATETIME,SYSDATETIMEOFFSET,SYSTEM_USER,SYSUTCDATETME,TAN,TERTIARY_WEIGHTS,TEXTPOS,TEXTPTR,TEXTVALID,TIMEDIFF,TIMEFROMPARTS,TIMEOFDAY,TIMESERIAL,TIMESTAMPADD,TIMEVALUE,TIME_FORMAT,TIME_TO_SEC,TODATETIMEOFFSET,TOTAL,TOTAL_CHANGES,TO_ASCII,TO_BASE64,TO_CHAR,TO_DATE,TO_DAYS,TO_HEX,TO_NUMBER,TO_SECONDS,TO_TIMESTAMP,TRANSACTION_TIMESTAMP,TRANSLATE,TRIGGER_NESTLEVEL,TRIM,TRUNC,TRUNCATE,TRY_CAST,TRY_CONVERT,TRY_PARSE,TYPEOF,TYPEPROPERTY,TYPE_ID,TYPE_NAME,UCASE,UNCOMPRESS,UNCOMPRESS_LENGTH,UNHEX,UNICODE,UNIX_TIMESTAMP,UNNEST,UPDATEXML,UPPER,UPPER_INC,UPPER_INF,USER_LOCK.SLEEP,USING,UUID,UUID_SHORT,VAR,VARIANCE,VARP,VAR_POP,VAR_SAMP,VERSION,WEEK,WEEKDAY,WEEKDAYNAME,WEEKOFYEAR,WIDTH_BUCKET,XMLAGG,XMLCOMMENT,XMLCONCAT,XMLELEMENT,XMLEXISTS,XMLFOREST,XMLFORMAT,XMLPI,XMLROOT,XMLTYPE,XML_IS_WELL_FORMED,XPATH,XPATH_EXISTS,YEAR,YEARWEEK,ZEROBLOB
Type
string
Application
Global

Key questions about this property

The answers below summarize the purpose, scope, default effect, and review scenarios for this property.

What does it do? It defines a default set of SQL functions that can be executed in passthrough mode, impacting database interactions.
What area does it affect? Database passthrough functions
What does the default mean? The default value is "ABS,ACOS,ADDDATE,ADDTIME,AGE,ANY,ARRAY_AGG,ARRAY_CAT,ARRAY_DIM,ARRAY_FILL,ARRAY_LENGTH,ARRAY_LOWER,ARRAY_NDIMS,ARRAY_PREPEND,ARRAY_TO_JSON,ARRAY_TO_STRING,ARRAY_UPPER,ASCII,ASIN,ASYMKEY_ID,ATAN,ATAN2,AVG,BIN,BINBINARY,BIT_AND,BIT_COUNT,BIT_LENGTH,BIT_OR,BIT_XOR,BOOL_AND,BOOL_OR,BTRIM,CAST,CBOOL,CBRT,CBYTE,CCUR,CDATE,CDBL,CEIL,CEILING,CHANGES,CHAR,CHARACTER_LENGTH,CHARINDEX,CHARSET,CHAR_LENGTH,CHECKSUM_AGG,CHOOSE,CHR,CINT,CLNG,CLOCK_TIMESTAMP,COALESCE,COL_LENGTH,COL_NAME,COMPRESS,CONCAT,CONCAT_WS,CONV,CONVERT,CONVERT_FROM,CONVERT_TO,CONVERT_TZ,COS,COT,COUNT,CRC32,CSNG,CUME_DIST,CURDATE,CURRENT_QUERY,CURRVAL,CURSOR_STATUS,CURTIME,CVAR,DATALENGTH,DATE,DATEADD,DATEDIFF,DATEFROMPARTS,DATENAME,DATEPART,DATESERIAL,DATETIME2FROMPARTS,DATETIMEFROMPARTS,DATETIMEOFFSETFROMPARTS,DATEVALUE,DATE_ADD,DATE_FORMAT,DATE_PART,DATE_SUB,DATE_TRUNC,DAVG,DAY,DAYNAME,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR,DCOUNT,DECODE,DEGREES,DENSE_RANK,DFIRST,DIFFERENCE,DLAST,DLOOKUP,DMAX,DMIN,DOTWALK,DSUM,DURATION_BETWEEN,DURATION_IN_DAYS,DURATION_IN_MONTHS,DURATION_IN_SECONDS,DV,ELT,ENCODE,ENUM_FIRST,ENUM_LAST,ENUM_RANGE,EOMONTH,EVENTDATA,EXISTS,EXP,EXTRACT,EXTRACTVALUE,EXTRACT_VALUE,FIELD,FIND_IN_SET,FIRST_VALUE,FLOOR,FORMAT,FOUND_ROWS,FROM_BASE64,FROM_DAYS,FROM_UNIXTIME,GETATTR,GETDATE,GETUTCDATE,GET_BIT,GET_BYTE,GET_FORMAT,GET_LOCK,GLIDE_CAST,GLIDE_DATE_TRUNC,GREATEST,GROUPING,GROUPING_ID,GROUP_CONCAT,HASHBYTES,HEX,HOUR,IF,IF EXISTS,IF NOT,IF NOT EXISTS,IFF,IFNULL,IIF,INDEXKEY_PROPERTY,INDEXPROPERTY,INDEX_COL,INET_ATON,INET_NTOA,INITCAP,INSTR,INSTRREV,ISDATE,ISEMPTY,ISFINITE,ISNULL,ISNUMERIC,IS_FREE_LOCK,IS_MEMBER,IS_OBJECTSIGNED,IS_ROLEMEMBER,IS_SRVROLEMEMBER,IS_USED_LOCK,JSON_KEYS,JULIANDAY,JUSTIFY_DAYS,JUSTIFY_HOURS,JUSTIFY_INTERVAL,KEY_GUID,KEY_ID,LAG,LASTVAL,LAST_INSERT_ID,LAST_INSERT_ROWID,LAST_VALUE,LCASE,LEAD,LEAST,LENGTH,LN,LOCATE,LOG,LOG10,LOWER,LOWER_INC,LOWER_INF,LPAD,LTRIM,MAKEDATE,MAKE_SET,MASKLEN,MASTER_POS_WAIT,MAX,MD5,MICROSECOND,MID,MIN,MINUTE,MKDIR,MOD,MONTH,MONTHNAME,NAME_CONST,NETMASK,NEXTVAL,NOW,NTH_VALUE,NTILE,NULLIF,NZ,OCT,OCTET_LENGTH,OPENQUERY,OPENROWSET,OPENXML,ORD,OVERLAPS,OVERLAY,PERCENTILE_COUNT,PERCENTILE_DISC,PERCENTILE_RANK,PERCENT_RANK,PERIOD_ADD,PERIOD_DIFF,PI,POSITION,POW,POWER,QUARTER,QUOTE,QUOTENAME,QUOTE_IDENT,QUOTE_LITERAL,QUOTE_NULLABLE,RADIANS,RAND,RANDOM,RANDOMBLOB,RANK,REGEXP_INSTR,REGEXP_MATCHES,REGEXP_REPLACE,REGEXP_SPLIT_TO_ARRAY,REGEXP_SPLIT_TO_TABLE,REGEXP_SUBSTR,RELEASE_LOCK,REPEAT,REPLACE,REVERSE,ROUND,ROW,ROW_COUNT,ROW_NUMBER,ROW_TO_JSON,RPAD,RTRIM,SECOND,SEC_TO_TIME,SETATTR,SETSEED,SETVAL,SET_BIT,SET_BYTE,SET_MASKLEN,SHA,SHA1,SHA2,SIGN,SIN,SMALLDATETIMEFROMPARTS,SOME,SPACE,SPLIT_PART,SQRT,STATEMENT_TIMESTAMP,STATS_DATE,STDDEV,STDDEV_POP,STDDEV_SAMP,STRCMP,STRCOMP,STRCONV,STRING_AGG,STRING_TO_ARRAY,STRPOS,STR_TO_DATE,STUFF,SUBDATE,SUBSTR,SUBSTRING,SUBSTRING_INDEX,SUBTIME,SUM,SWITCHOFFET,SYS.STRAGG,SYSDATE,SYSDATETIME,SYSDATETIMEOFFSET,SYSTEM_USER,SYSUTCDATETME,TAN,TERTIARY_WEIGHTS,TEXTPOS,TEXTPTR,TEXTVALID,TIMEDIFF,TIMEFROMPARTS,TIMEOFDAY,TIMESERIAL,TIMESTAMPADD,TIMEVALUE,TIME_FORMAT,TIME_TO_SEC,TODATETIMEOFFSET,TOTAL,TOTAL_CHANGES,TO_ASCII,TO_BASE64,TO_CHAR,TO_DATE,TO_DAYS,TO_HEX,TO_NUMBER,TO_SECONDS,TO_TIMESTAMP,TRANSACTION_TIMESTAMP,TRANSLATE,TRIGGER_NESTLEVEL,TRIM,TRUNC,TRUNCATE,TRY_CAST,TRY_CONVERT,TRY_PARSE,TYPEOF,TYPEPROPERTY,TYPE_ID,TYPE_NAME,UCASE,UNCOMPRESS,UNCOMPRESS_LENGTH,UNHEX,UNICODE,UNIX_TIMESTAMP,UNNEST,UPDATEXML,UPPER,UPPER_INC,UPPER_INF,USER_LOCK.SLEEP,USING,UUID,UUID_SHORT,VAR,VARIANCE,VARP,VAR_POP,VAR_SAMP,VERSION,WEEK,WEEKDAY,WEEKDAYNAME,WEEKOFYEAR,WIDTH_BUCKET,XMLAGG,XMLCOMMENT,XMLCONCAT,XMLELEMENT,XMLEXISTS,XMLFOREST,XMLFORMAT,XMLPI,XMLROOT,XMLTYPE,XML_IS_WELL_FORMED,XPATH,XPATH_EXISTS,YEAR,YEARWEEK,ZEROBLOB", which is the baseline setting used unless it is changed.
When should you review it? Review this property when configuring database access or security settings.

Out of the box property record

Raw metadata from the property record.

Property name glide.db.passthrough.func.allowlist_default
Sys ID f2dccfa3ff013210959cffffffffff4a
Type string
Application Global
Default value ABS,ACOS,ADDDATE,ADDTIME,AGE,ANY,ARRAY_AGG,ARRAY_CAT,ARRAY_DIM,ARRAY_FILL,ARRAY_LENGTH,ARRAY_LOWER,ARRAY_NDIMS,ARRAY_PREPEND,ARRAY_TO_JSON,ARRAY_TO_STRING,ARRAY_UPPER,ASCII,ASIN,ASYMKEY_ID,ATAN,ATAN2,AVG,BIN,BINBINARY,BIT_AND,BIT_COUNT,BIT_LENGTH,BIT_OR,BIT_XOR,BOOL_AND,BOOL_OR,BTRIM,CAST,CBOOL,CBRT,CBYTE,CCUR,CDATE,CDBL,CEIL,CEILING,CHANGES,CHAR,CHARACTER_LENGTH,CHARINDEX,CHARSET,CHAR_LENGTH,CHECKSUM_AGG,CHOOSE,CHR,CINT,CLNG,CLOCK_TIMESTAMP,COALESCE,COL_LENGTH,COL_NAME,COMPRESS,CONCAT,CONCAT_WS,CONV,CONVERT,CONVERT_FROM,CONVERT_TO,CONVERT_TZ,COS,COT,COUNT,CRC32,CSNG,CUME_DIST,CURDATE,CURRENT_QUERY,CURRVAL,CURSOR_STATUS,CURTIME,CVAR,DATALENGTH,DATE,DATEADD,DATEDIFF,DATEFROMPARTS,DATENAME,DATEPART,DATESERIAL,DATETIME2FROMPARTS,DATETIMEFROMPARTS,DATETIMEOFFSETFROMPARTS,DATEVALUE,DATE_ADD,DATE_FORMAT,DATE_PART,DATE_SUB,DATE_TRUNC,DAVG,DAY,DAYNAME,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR,DCOUNT,DECODE,DEGREES,DENSE_RANK,DFIRST,DIFFERENCE,DLAST,DLOOKUP,DMAX,DMIN,DOTWALK,DSUM,DURATION_BETWEEN,DURATION_IN_DAYS,DURATION_IN_MONTHS,DURATION_IN_SECONDS,DV,ELT,ENCODE,ENUM_FIRST,ENUM_LAST,ENUM_RANGE,EOMONTH,EVENTDATA,EXISTS,EXP,EXTRACT,EXTRACTVALUE,EXTRACT_VALUE,FIELD,FIND_IN_SET,FIRST_VALUE,FLOOR,FORMAT,FOUND_ROWS,FROM_BASE64,FROM_DAYS,FROM_UNIXTIME,GETATTR,GETDATE,GETUTCDATE,GET_BIT,GET_BYTE,GET_FORMAT,GET_LOCK,GLIDE_CAST,GLIDE_DATE_TRUNC,GREATEST,GROUPING,GROUPING_ID,GROUP_CONCAT,HASHBYTES,HEX,HOUR,IF,IF EXISTS,IF NOT,IF NOT EXISTS,IFF,IFNULL,IIF,INDEXKEY_PROPERTY,INDEXPROPERTY,INDEX_COL,INET_ATON,INET_NTOA,INITCAP,INSTR,INSTRREV,ISDATE,ISEMPTY,ISFINITE,ISNULL,ISNUMERIC,IS_FREE_LOCK,IS_MEMBER,IS_OBJECTSIGNED,IS_ROLEMEMBER,IS_SRVROLEMEMBER,IS_USED_LOCK,JSON_KEYS,JULIANDAY,JUSTIFY_DAYS,JUSTIFY_HOURS,JUSTIFY_INTERVAL,KEY_GUID,KEY_ID,LAG,LASTVAL,LAST_INSERT_ID,LAST_INSERT_ROWID,LAST_VALUE,LCASE,LEAD,LEAST,LENGTH,LN,LOCATE,LOG,LOG10,LOWER,LOWER_INC,LOWER_INF,LPAD,LTRIM,MAKEDATE,MAKE_SET,MASKLEN,MASTER_POS_WAIT,MAX,MD5,MICROSECOND,MID,MIN,MINUTE,MKDIR,MOD,MONTH,MONTHNAME,NAME_CONST,NETMASK,NEXTVAL,NOW,NTH_VALUE,NTILE,NULLIF,NZ,OCT,OCTET_LENGTH,OPENQUERY,OPENROWSET,OPENXML,ORD,OVERLAPS,OVERLAY,PERCENTILE_COUNT,PERCENTILE_DISC,PERCENTILE_RANK,PERCENT_RANK,PERIOD_ADD,PERIOD_DIFF,PI,POSITION,POW,POWER,QUARTER,QUOTE,QUOTENAME,QUOTE_IDENT,QUOTE_LITERAL,QUOTE_NULLABLE,RADIANS,RAND,RANDOM,RANDOMBLOB,RANK,REGEXP_INSTR,REGEXP_MATCHES,REGEXP_REPLACE,REGEXP_SPLIT_TO_ARRAY,REGEXP_SPLIT_TO_TABLE,REGEXP_SUBSTR,RELEASE_LOCK,REPEAT,REPLACE,REVERSE,ROUND,ROW,ROW_COUNT,ROW_NUMBER,ROW_TO_JSON,RPAD,RTRIM,SECOND,SEC_TO_TIME,SETATTR,SETSEED,SETVAL,SET_BIT,SET_BYTE,SET_MASKLEN,SHA,SHA1,SHA2,SIGN,SIN,SMALLDATETIMEFROMPARTS,SOME,SPACE,SPLIT_PART,SQRT,STATEMENT_TIMESTAMP,STATS_DATE,STDDEV,STDDEV_POP,STDDEV_SAMP,STRCMP,STRCOMP,STRCONV,STRING_AGG,STRING_TO_ARRAY,STRPOS,STR_TO_DATE,STUFF,SUBDATE,SUBSTR,SUBSTRING,SUBSTRING_INDEX,SUBTIME,SUM,SWITCHOFFET,SYS.STRAGG,SYSDATE,SYSDATETIME,SYSDATETIMEOFFSET,SYSTEM_USER,SYSUTCDATETME,TAN,TERTIARY_WEIGHTS,TEXTPOS,TEXTPTR,TEXTVALID,TIMEDIFF,TIMEFROMPARTS,TIMEOFDAY,TIMESERIAL,TIMESTAMPADD,TIMEVALUE,TIME_FORMAT,TIME_TO_SEC,TODATETIMEOFFSET,TOTAL,TOTAL_CHANGES,TO_ASCII,TO_BASE64,TO_CHAR,TO_DATE,TO_DAYS,TO_HEX,TO_NUMBER,TO_SECONDS,TO_TIMESTAMP,TRANSACTION_TIMESTAMP,TRANSLATE,TRIGGER_NESTLEVEL,TRIM,TRUNC,TRUNCATE,TRY_CAST,TRY_CONVERT,TRY_PARSE,TYPEOF,TYPEPROPERTY,TYPE_ID,TYPE_NAME,UCASE,UNCOMPRESS,UNCOMPRESS_LENGTH,UNHEX,UNICODE,UNIX_TIMESTAMP,UNNEST,UPDATEXML,UPPER,UPPER_INC,UPPER_INF,USER_LOCK.SLEEP,USING,UUID,UUID_SHORT,VAR,VARIANCE,VARP,VAR_POP,VAR_SAMP,VERSION,WEEK,WEEKDAY,WEEKDAYNAME,WEEKOFYEAR,WIDTH_BUCKET,XMLAGG,XMLCOMMENT,XMLCONCAT,XMLELEMENT,XMLEXISTS,XMLFOREST,XMLFORMAT,XMLPI,XMLROOT,XMLTYPE,XML_IS_WELL_FORMED,XPATH,XPATH_EXISTS,YEAR,YEARWEEK,ZEROBLOB
Description Default list of allowed SQL functions
Updated 2025-11-12 14:03:21

Sources

Official references and nearby text excerpts where this property appears.

More in glide.db

Other properties in the same namespace.

All 41 properties in glide.db →