Hello, World!

Welcome to FeatureQL!

This page introduces the fundamental concepts through simple examples that you can run interactively.

Basic value selection

The most basic query returns a single value:

This simple query demonstrates FeatureQL's SQL-compatible syntax. Like SQL, you can return literal values directly.

Named features

You can name your returned values using AS:

Named features become reusable in other parts of your query and can be persisted for future use across different queries.

Computed values

Values can be computed using operators and functions:

FeatureQL supports both traditional SQL operators (|| for concatenation) and equivalent function calls (CONCAT()). Both approaches produce identical results, allowing you to choose the syntax that best fits your coding style.

Flat syntax

Features can reference other features defined in the same query. You do not need to create sequential or nested CTEs in FeatureQL.

Case insensitive syntax

Queries are case insensitive: