The long-awaited Dutch localization of DuckDB's SQL dialect
Installing and Loading
INSTALL eenddb FROM community;
LOAD eenddb;
Example
LOAD eenddb;
CALL enable_dutch_parser();
MAAK TABEL eenden (id GEHEEL_GETAL, naam TEKST, gewicht KOMMAGETAL);
TOEVOEGEN AAN eenden WAARDEN (1, 'Donald', 1.2), (2, 'Daffy', 1.5), (3, 'Dagobert', 3.7);
SELECTEER * VAN eenden WAARBIJ gewicht > 1.3 VOLGORDE PER naam;
About eenddb
EendDB ("eend" is Dutch for "duck") is the official Dutch-language SQL dialect for DuckDB. After years of demand from the Dutch-speaking data engineering community, SQL queries can now be written in fluent Nederlands.
The extension provides a complete localization of DuckDB's SQL syntax, including SELECTEER (SELECT), VAN (FROM), WAARBIJ (WHERE), GROEP PER (GROUP BY), VOLGORDE PER (ORDER BY), SAMENVOEGEN (JOIN), TOEVOEGEN AAN (INSERT INTO), BIJWERKEN (UPDATE), VERWIJDEREN VAN (DELETE FROM), MAAK TABEL (CREATE TABLE), and GOOI_WEG TABEL (DROP TABLE), among others.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| disable_dutch_parser | table | NULL | NULL | |
| eenddb | scalar | NULL | NULL | |
| enable_dutch_parser | table | NULL | NULL |
Overloaded Functions
| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|
Added Types
| type_name | type_size | logical_type | type_category | internal | |———–|———-:|————–|—————|———-|
Added Settings
| name | description | input_type | scope | aliases | |——|————-|————|——-|———|