Skip to content

The data farm

Extensions Connect systems and add SQL capabilities.
Orchard Preview Discover, subscribe to, and reuse connectors.
VGI Run custom or reusable workers from SQL.
Rowfence Preview Enforce row, column, and function access.
Haybarn Bring DuckDB into the enterprise.
Cupola Browse and query workers in the browser.
Grainlift Preview Proxy databases or build ADBC services.

See how it all fits together →

Blog

Search Query.Farm

Also search function names

Extensions 🌳 Orchard

About Contact Newsletter Schedule Meeting

Haybarn Overview Install

Extensions

Find extensions Installing extensions Build status Contribute

Functions Security FAQ

Search functions

⌕ Search functions /

⌂ Overview ƒ All functions 847

Explore by category

AaText & patterns74 ∑Numbers & math56 ◷Dates & time59 [ ]Lists & arrays114 { }JSON41 ▥Aggregates72 ⊞Maps & structs18 ▤Files & tables16 ⌘Database & utility369 ±Operators28

Put it to work

▧ SQL recipes Try it ▷ Playground ◴ Function changes ⌘ For agents API

Functions/Database & utility/getenv

Database & utility Scalar

getenv()

Arguments & returns

`getenv(col0)`

Scalar

Overload link	`col0`	Returns
#01	`VARCHAR`	`VARCHAR`

DuckDB documentation

Utility Functions

Available in DuckDB 1.5 DuckDB 1.4 DuckDB 1.3

ON THIS PAGE

Arguments & returns DuckDB documentation

Search functions

⌕Search functions and examples

Include other releases

Search descriptions, arguments, SQL examples, and guides.

Try

Browse functions →

DuckDB 1.3.2↑ ↓ Navigate · ↵ Open

Start with the outcome

What do you need your data to do?

Query.Farm gives DuckDB practical paths into the systems and capabilities your work depends on.

Talk with us See the whole platform →

Extend Add a SQL capability Browse installable DuckDB extensions. → Connect Reach an external system Turn APIs, services, models, and code into queryable tables. → Operate Run DuckDB in production Use signed builds and a production-focused distribution. →

Dispatch

New extensions, releases, and technical work from Query.Farm.

Email address

Products

Cupola
DuckDB Extensions
Grainlift
Haybarn
Orchard
Rowfence
VGI

Company

About
Vision
Consulting
Blog
Media Kit

Resources

VGI documentation
Haybarn status
Security
Licenses

Connect

Schedule a meeting
Contact
Newsletter
GitHub

© 2025–2026 Query Farm LLC · All rights reserved

Privacy Terms [email protected]