Skip to content
v1.36.1
Compare
Pricing
Docs
Account
Search
Ctrl
K
Cancel
Install
→
Get Started
Install
Connect
Execute a Query
Install Visual Studio Code
Connecting
Connections
Create
Edit
Connect
Roles
Refresh
Copy
Group
Color
Delete
Schema Loading
Variables
Watched Folders
Folder Connections
Monitoring
Auto SSL
Import
Tunnels
Zero Config
Cloud Providers
Connect
Supported Providers
Authentication Profiles
OAuth2 / OIDC
AWS
Command
.pgpass File
Working with Data
Query
SQL Editor
Query Builder
Autocomplete
Parameters
Inline Completion
Transaction Control
History
History Sync & Backup
Execution Plans
Multi-Statement Run Tab
Favorites
Library
Scratch Files
SQL Formatting
Editor Connection Idle Timeout
WHERE Detection
Data
Edit
Copy
Explore
Export
Import
Compare
Join
Union
Relationships
Secure Share
Visualize
Inspector
Row Limit
Data Search
Formatters
Tab Behavior
Backup & Restore
Saved Filters
Streaming
Keyboard Shortcuts
DB Explorer
Create or Edit Tables
Rename Tables
Truncate Table
Drop Table
Entity Relationship Diagram
Stored Procedures
Execute SQL File
Filter
Keyboard Shortcuts
Quick Open
Notebooks
Getting Started
Exporting
Cell Locking
Python Integration
AI
Query Builder
Data Grid
Copilot Tools
MCP
Custom Provider
Models and Configuration
Privacy and Security
Security
Overview
Password Storage
Telemetry
Account
Sign In
Managing Team Seats
Team Roles
Offline License Activation
Container Deployment
Reference
Supported Databases
Aerospike
Amazon Athena
Amazon DocumentDB
Amazon DynamoDB
Apache CouchDB
Apache Derby
Apache Doris
Apache Druid
Apache Hive
Apache Iceberg
Apache Impala
Apache Kafka
Apache Pinot
Avro
Azure SQL
Azure Synapse
BigQuery
Bunny Database
Cassandra
ChromaDB
Preview
ClickHouse
Cloudflare D1
Cloudflare R2 SQL
CockroachDB
Couchbase
Preview
CSV
Cube
Dameng
Preview
Databricks
Dataverse
DuckDB
DuckLake
Elasticsearch
Exasol
Preview
Excel
Firebase
Firebird
Preview
Google Spanner
Greenplum
H2
IBM DB2
IBM i
InfluxDB
KingbaseES
LanceDB
Preview
libSQL
MariaDB
Memcached
Memgraph
Microsoft Access
Microsoft Fabric
Milvus
Preview
MongoDB
MotherDuck
MySQL
Neo4j
Netezza
OpenSearch
Oracle
Parquet
PGlite
Pinecone
Preview
PostgreSQL
PostHog
Preview
Qdrant
Preview
QuestDB
RabbitMQ
RavenDB
Redis
Redshift
RisingWave
Salesforce
SAP ASE (Sybase)
SAP HANA
Preview
ScyllaDB
SingleStore
Snowflake
SQL Server
SQLite
StarRocks
Stripe
Preview
SurrealDB
Teradata
Preview
TiDB
Timescale
Trino
TypeDB
Preview
Vertica
Weaviate
Preview
YugabyteDB
SQL Reference
ABS
ACOS
ACOSH
ADD_MONTHS
ADDDATE
ADDTIME
AGE
AGGREGATE
ALIAS
ALL
ALTER
ANALYZE
AND
ANY
ANY_VALUE
APPLY
APPROX_COUNT_DISTINCT
APPROX_QUANTILE
APPROX_TOP_K
ARBITRARY
ARG_MAX
ARG_MAX_NULL
ARG_MAX_NULLS_LAST
ARG_MIN
ARG_MIN_NULL
ARG_MIN_NULLS_LAST
ARGMAX
ARGMIN
ARRAY
ARRAY_AGG
ARRAY_AGGR
ARRAY_AGGREGATE
ARRAY_APPLY
ARRAY_CAT
ARRAY_CONCAT
ARRAY_CONTAINS
ARRAY_COSINE_DISTANCE
ARRAY_COSINE_SIMILARITY
ARRAY_CROSS_PRODUCT
ARRAY_DISTANCE
ARRAY_DISTINCT
ARRAY_DOT_PRODUCT
ARRAY_EXTRACT
ARRAY_FILTER
ARRAY_GRADE_UP
ARRAY_HAS
ARRAY_HAS_ALL
ARRAY_HAS_ANY
ARRAY_INDEXOF
ARRAY_INNER_PRODUCT
ARRAY_INTERSECT
ARRAY_LENGTH
ARRAY_MAX_CARDINALITY
ARRAY_NEGATIVE_DOT_PRODUCT
ARRAY_NEGATIVE_INNER_PRODUCT
ARRAY_POSITION
ARRAY_REDUCE
ARRAY_RESIZE
ARRAY_REVERSE_SORT
ARRAY_SELECT
ARRAY_SLICE
ARRAY_SORT
ARRAY_TRANSFORM
ARRAY_UNIQUE
ARRAY_VALUE
ARRAY_WHERE
ARRAY_ZIP
AS
ASC
ASCII
ASCIISTR
ASENSITIVE
ASIN
ASINH
ATAN
ATAN2
ATANH
AUTHORIZATION
AVG
BACKUP
BAR
BASE64
BEGIN
BETWEEN
BFILENAME
BIGINT
BIN
BIN_TO_NUM
BINARY
BIT_AND
BIT_COUNT
BIT_LENGTH
BIT_OR
BIT_POSITION
BIT_XOR
BITAND
BITSTRING
BITSTRING_AGG
BLOB
BOOL_AND
BOOL_OR
BOOLEAN
BREAK
BTRIM
BULK
CALL
CAN_CAST_IMPLICITLY
CARDINALITY
CASCADE
CASE
CAST
CAST_TO_TYPE
CBRT
CEIL
CEILING
CENTURY
CHANGE
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHARINDEX
CHARTOROWID
CHECK
CHECKPOINT
CHR
CLOB
CLOSE
CLUSTERED
COALESCE
COLLATE
COLLECT
COMMIT
COMPOSE
COMPUTE
CONCAT
CONCAT_WS
CONCURRENTLY
CONNECTION_ID
CONSTANT_OR_NULL
CONSTRAINT
CONTAINS
CONTAINSTABLE
CONTINUE
CONV
CONVERT
COPY
CORR
CORRESPONDING
COS
COSH
COT
COUNT
COUNT_IF
COUNTIF
COVAR_POP
COVAR_SAMP
CREATE
CREATE_SORT_KEY
CROSS
CUBE
CUME_DIST
CURDATE
CURRENT_CATALOG
CURRENT_CONNECTION_ID
CURRENT_DATABASE
CURRENT_DATE
CURRENT_DEFAULT_TRANSFORM_GROUP
CURRENT_PATH
CURRENT_QUERY
CURRENT_QUERY_ID
CURRENT_ROLE
CURRENT_SCHEMA
CURRENT_SCHEMAS
CURRENT_SETTING
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TRANSACTION_ID
CURRENT_USER
CURRVAL
CURSOR
CURTIME
DAMERAU_LEVENSHTEIN
DATABASE
DATALENGTH
DATE_ADD
DATE_DIFF
DATE_FORMAT
DATE_PART
DATE_SUB
DATE_TRUNC
DATEADD
DATEDIFF
DATEFROMPARTS
DATENAME
DATEPART
DATESUB
DATETRUNC
DAY
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DBCC
DBTIMEZONE
DEALLOCATE
DEC
DECADE
DECFLOAT
DECIMAL
DECLARE
DECODE
DECOMPOSE
DEFAULT
DEFERRABLE
DEFINE
DEGREES
DELAYED
DELETE
DENSE_RANK
DENY
DEREF
DESC
DESCRIBE
DETERMINISTIC
DIFFERENCE
DISTINCT
DISTINCTROW
DIV
DO
DOUBLE
DROP
DUAL
DUMP
EDITDIST3
ELEMENT_AT
ELSE
ELSEIF
EMPTY_BLOB
EMPTY_CLOB
ENCLOSED BY
ENCODE
END
END-EXEC
ENDS_WITH
ENTROPY
ENUM_CODE
ENUM_FIRST
ENUM_LAST
ENUM_RANGE
ENUM_RANGE_BOUNDARY
EPOCH
EPOCH_MS
EPOCH_NS
EPOCH_US
EQUI_WIDTH_BINS
ERA
ERROR
ESCAPE
EVEN
EVERY
EXCEPT
EXEC
EXECUTE
EXISTS
EXIT
EXP
EXPLAIN
EXTERNAL
EXTRACT
FACTORIAL
FAVG
FETCH
FIELD
FILLFACTOR
FILTER
FIND_IN_SET
FIRST
FIRST_VALUE
FLATTEN
FLOAT
FLOAT4
FLOAT8
FLOOR
FOR
FOREIGN KEY
FORMAT
FORMAT_BYTES
FORMATREADABLEDECIMALSIZE
FORMATREADABLESIZE
FREETEXT
FREETEXTTABLE
FREEZE
FROM
FROM_BASE64
FROM_BINARY
FROM_DAYS
FROM_HEX
FROM_TZ
FSUM
FULL
FULLTEXT
FUNCTION
GAMMA
GCD
GEN_RANDOM_UUID
GENERATE_SERIES
GENERATED
GET
GET_BIT
GET_CURRENT_TIMESTAMP
GET_TYPE
GETDATE
GETUTCDATE
GLOB
GLOBAL
GOTO
GRADE_UP
GRANT
GREATEST
GREATEST_COMMON_DIVISOR
GROUP_CONCAT
GROUP_ID
GROUP BY
HAMMING
HASH
HAVING
HEX
HEXTORAW
HIGH_PRIORITY
HISTOGRAM
HISTOGRAM_EXACT
HOLD
HOLDLOCK
HOUR
HOUR_MICROSECOND
HOUR_SECOND
IDENTITY
IDENTITY_INSERT
IF
IFNULL
IGNORE
ILIKE
ILIKE_ESCAPE
IN
IN_SEARCH_PATH
INDEX
INFILE
INITCAP
INITIAL
INITIALLY
INNER
INOUT
INSENSITIVE
INSERT
INSTR
INSTR2
INSTR4
INSTRB
INSTRC
INT
INT1
INT2
INT4
INT8
INTEGER
INTERSECT
INTERSECTION
INTERVAL
INTO
IO_BEFORE_GTIDS
IS
IS_HISTOGRAM_OTHER_BIN
ISDATE
ISFINITE
ISINF
ISNAN
ISNULL
ISNUMERIC
ISODOW
ISOYEAR
ITERATE
JACCARD
JARO_SIMILARITY
JARO_WINKLER_SIMILARITY
JOIN
JSON
JSON_ARRAY
JSON_ARRAYAGG
JSON_EXISTS
JSON_OBJECT
JSON_OBJECTAGG
JSON_QUERY
JSON_SCALAR
JSON_TABLE
JSON_VALUE
JULIAN
JULIANDAY
KAHAN_SUM
KEY
KEYS
KILL
KURTOSIS
KURTOSIS_POP
LAG
LANGUAGE
LARGE
LAST
LAST_DAY
LAST_INSERT_ID
LAST_VALUE
LATERAL
LCASE
LCM
LEAD
LEADING
LEAST
LEAST_COMMON_MULTIPLE
LEAVE
LEFT
LEFT_GRAPHEME
LEN
LENGTH
LENGTH_GRAPHEME
LENGTH2
LENGTH4
LENGTHB
LENGTHC
LEVENSHTEIN
LGAMMA
LIKE
LIKE_ESCAPE
LIKE_REGEX
LIMIT
LINES
LIST
LIST_AGGR
LIST_AGGREGATE
LIST_APPLY
LIST_CAT
LIST_CONCAT
LIST_CONTAINS
LIST_COSINE_DISTANCE
LIST_COSINE_SIMILARITY
LIST_DISTANCE
LIST_DISTINCT
LIST_DOT_PRODUCT
LIST_ELEMENT
LIST_EXTRACT
LIST_FILTER
LIST_GRADE_UP
LIST_HAS
LIST_HAS_ALL
LIST_HAS_ANY
LIST_INDEXOF
LIST_INNER_PRODUCT
LIST_INTERSECT
LIST_NEGATIVE_DOT_PRODUCT
LIST_NEGATIVE_INNER_PRODUCT
LIST_PACK
LIST_POSITION
LIST_REDUCE
LIST_RESIZE
LIST_REVERSE_SORT
LIST_SELECT
LIST_SLICE
LIST_SORT
LIST_TRANSFORM
LIST_UNIQUE
LIST_VALUE
LIST_WHERE
LIST_ZIP
LISTAGG
LN
LNNVL
LOAD
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOCATE
LOCK
LOG
LOG10
LOG2
LONG
LONGBLOB
LONGTEXT
LOOP
LOW_PRIORITY
LOWER
LPAD
LTRIM
MAD
MAKE_DATE
MAKE_TIME
MAKE_TIMESTAMP
MAKE_TIMESTAMP_MS
MAKE_TIMESTAMP_NS
MAKE_TYPE
MAKEDATE
MAKETIME
MAP
MAP_CONCAT
MAP_CONTAINS
MAP_ENTRIES
MAP_EXTRACT
MAP_EXTRACT_VALUE
MAP_FROM_ENTRIES
MAP_KEYS
MAP_VALUES
MATCH
MATCH_NUMBER
MATCH_RECOGNIZE
MATCHES
MAX
MAX_BY
MAXVALUE
MD5
MD5_NUMBER
MEAN
MEDIAN
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MEMBER
MERGE
METHOD
MICROSECOND
MID
MILLENNIUM
MILLISECOND
MIN
MIN_BY
MINUTE
MINUTE_SECOND
MISMATCHES
MOD
MODE
MODIFIES
MONTH
MONTHNAME
MONTHS_BETWEEN
MULTISET
NANOSECOND
NANVL
NATIONAL
NATURAL
NCHAR
NCHR
NCLOB
NEW
NEW_TIME
NEXT_DAY
NEXTAFTER
NEXTVAL
NFC_NORMALIZE
NOCHECK
NONCLUSTERED
NORMALIZE
NORMALIZED_INTERVAL
NOT
NOT_ILIKE_ESCAPE
NOT_LIKE_ESCAPE
NOW
NTH_VALUE
NTILE
NULL
NULLIF
NUMERIC
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
NVL2
OCTET_LENGTH
OFFSET
OLD
OLD_PASSWORD
ON
OPEN
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENXML
OPTIMIZE
OPTIMIZER_COSTS
OPTION
OPTIONALLY
OR
ORD
ORDER BY
OUT
OUTER
OUTFILE
OVER
OVERLAPS
OVERLAY
PARSE_DIRNAME
PARSE_DIRPATH
PARSE_DUCKDB_LOG_MESSAGE
PARSE_FILENAME
PARSE_FORMATTED_BYTES
PARSE_PATH
PARTITION
PASSWORD
PATINDEX
PATTERN
PER
PERCENT
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
PERIOD
PERIOD_ADD
PERIOD_DIFF
PI
PIVOT
POSITION
POW
POWER
PRECISION
PREFIX
PREPARE
PRIMARY KEY
PRINT
PRINTF
PROC
PROCEDURE
PRODUCT
PURGE
QUANTILE
QUANTILE_CONT
QUANTILE_DISC
QUARTER
QUERY
QUERY_TABLE
QUOTENAME
RADIANS
RAISERROR
RAND
RANDOM
RANGE
RANK
RAWTOHEX
READ_BLOB
READ_CSV
READ_CSV_AUTO
READ_JSON
READ_JSON_AUTO
READ_PARQUET
READ_TEXT
READTEXT
REAL
RECONFIGURE
RECURSIVE
REDUCE
REFERENCES
REGEXP
REGEXP_COUNT
REGEXP_ESCAPE
REGEXP_EXTRACT
REGEXP_EXTRACT_ALL
REGEXP_FULL_MATCH
REGEXP_INSTR
REGEXP_MATCHES
REGEXP_REPLACE
REGEXP_SPLIT_TO_ARRAY
REGEXP_SUBSTR
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
RELEASE
REMAINDER
REMAP_STRUCT
RENAME
REPEAT
REPLACE
REPLACE_TYPE
REQUIRE
RESERVOIR_QUANTILE
RESTORE
RESTRICT
RETURN
RETURNING
RETURNS
REVERSE
REVERT
REVOKE
RIGHT
RIGHT_GRAPHEME
RLIKE
ROLLBACK
ROLLUP
ROUND
ROW
ROW_NUMBER
ROWCOUNT
ROWGUIDCOL
ROWNUM
RPAD
RTRIM
RULE
SAVEPOINT
SCHEMA
SCROLL
SEC_TO_TIME
SECOND
SEEK
SELECT
SEM
SEMANTICKEYPHRASETABLE
SEMANTICSIMILARITYDETAILSTABLE
SEMANTICSIMILARITYTABLE
SENSITIVE
SEPARATOR
SESSION_USER
SESSIONPROPERTY
SESSIONTIMEZONE
SET
SET_BIT
SETSEED
SHA1
SHA256
SHOW
SHUTDOWN
SIGN
SIGNAL
SIGNBIT
SIMILAR
SIN
SINH
SKEWNESS
SKIP
SLEEP_MS
SMALLINT
SNIFF_CSV
SOME
SOUNDEX
SPACE
SPATIAL
SPECIFIC
SPECIFICTYPE
SPLIT
SQL_BIG_RESULT
SQL_CALC_FOUND_ROWS
SQL_SMALL_RESULT
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQRT
SSL
ST_ASBINARY
ST_ASTEXT
ST_ASWKB
ST_ASWKT
ST_CRS
ST_GEOMFROMWKB
ST_INTERSECTS_EXTENT
ST_SETCRS
START
STARTING
STARTS_WITH
STATISTICS
STATS
STDDEV
STDDEV_POP
STDDEV_SAMP
STORED
STR
STR_SPLIT
STR_SPLIT_REGEX
STR_TO_DATE
STRAIGHT_JOIN
STRCMP
STRFTIME
STRING_AGG
STRING_SPLIT
STRING_SPLIT_REGEX
STRING_TO_ARRAY
STRIP_ACCENTS
STRLEN
STRPOS
STRPTIME
STRUCT_CONCAT
STRUCT_CONTAINS
STRUCT_EXTRACT
STRUCT_EXTRACT_AT
STRUCT_HAS
STRUCT_INDEXOF
STRUCT_INSERT
STRUCT_KEYS
STRUCT_PACK
STRUCT_POSITION
STRUCT_UPDATE
STRUCT_VALUES
STUFF
SUBDATE
SUBMULTISET
SUBSTR
SUBSTRING
SUBSTRING_GRAPHEME
SUBSTRING_INDEX
SUBTIME
SUFFIX
SUM
SUM_NO_OVERFLOW
SUMKAHAN
SWITCH
SYS_CONTEXT
SYSDATE
SYSTEM_TIME
SYSTEM_USER
SYSTIMESTAMP
TABLE
TABLESAMPLE
TAN
TANH
TERMINATED
TEXTSIZE
THEN
TIME_BUCKET
TIME_FORMAT
TIME_TO_SEC
TIMEDIFF
TIMESTAMP
TIMETZ_BYTE_COMPARABLE
TIMEZONE
TIMEZONE_HOUR
TIMEZONE_MINUTE
TINYBLOB
TINYINT
TINYTEXT
TO_BASE
TO_BASE64
TO_BINARY
TO_CENTURIES
TO_CHAR
TO_CLOB
TO_DATE
TO_DAYS
TO_DECADES
TO_DSINTERVAL
TO_HEX
TO_HOURS
TO_LOB
TO_MICROSECONDS
TO_MILLENNIA
TO_MILLISECONDS
TO_MINUTES
TO_MONTHS
TO_MULTI_BYTE
TO_NCLOB
TO_NUMBER
TO_QUARTERS
TO_SECONDS
TO_SINGLE_BYTE
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_WEEKS
TO_YEARS
TO_YMINTERVAL
TOP
TRAILING
TRANSACTION
TRANSACTION_TIMESTAMP
TRANSLATE
TRANSLATION
TREAT
TRIGGER
TRIM
TRUE
TRUNC
TRUNCATE
TRY_CAST
TRY_CONVERT
TRY_STRPTIME
TXID_CURRENT
TYPEOF
TZ_OFFSET
UCASE
UESCAPE
UID
UNBIN
UNHEX
UNICODE
UNION
UNION_EXTRACT
UNION_TAG
UNION_VALUE
UNIQUE
UNLOCK
UNNEST
UNPIVOT
UNPIVOT_LIST
UNSIGNED
UPDATE
UPDATETEXT
UPPER
URL_DECODE
URL_ENCODE
USAGE
USE
USER
USER_NAME
USERENV
USING
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_EXTRACT_TIMESTAMP
UUID_EXTRACT_VERSION
UUIDV4
UUIDV7
VALUE
VALUES
VAR_POP
VAR_SAMP
VARBINARY
VARCHAR
VARIADIC
VARIANCE
VARIANT_NORMALIZE
VARIANT_TYPEOF
VARYING
VECTOR_TYPE
VERBOSE
VERSION
VIEW
VIRTUAL
VSIZE
WAITFOR
WEEK
WEEKDAY
WEEKOFYEAR
WHEN
WHENEVER
WHERE
WHILE
WIDTH_BUCKET
WITH
WITHIN GROUP
WRITE_LOG
WRITETEXT
XOR
YEAR
YEAR_MONTH
YEARWEEK
ZEROFILL
API
VSCode Extension API
Changelog
Help & Support
Debug & Troubleshoot
FAQ
Getting Help
GitHub
Discord
Select theme
Dark
Light
Auto
PREFIX
DuckDB
prefix(string, search_string)
Section titled “prefix(string, search_string)”
string: VARCHAR
search_string: VARCHAR
Example
Section titled “Example”
SELECT
prefix(
'
abc
'
,
'
ab
'
);