# Support for DuckDB \[DONE\]

**URL:** <https://community.easymorph.com/t/support-for-duckdb-done/5434>\
**Category:** Feature requests\
**Created:** [July 13, 2024, 4:17pm UTC](https://community.easymorph.com/t/support-for-duckdb-done/5434 "2024-07-13T16:17:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![CTN](https://community.easymorph.com/letter_avatar_proxy/v4/letter/c/e19adc/32.png) [@CTN](https://community.easymorph.com/u/CTN)\
**Post date:** [July 13, 2024, 4:17pm UTC](https://community.easymorph.com/t/support-for-duckdb-done/5434/1 "2024-07-13T16:17:29Z")

</div>

Do you support or do you have any plans to support the ability to read/write files to DuckDB. There is an ODBC driver is that the best solution? So far have been unable to get the ODBC driver to work and Easymorph doesn't display any errors when trying to create table or insert data.

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [July 16, 2024, 12:15am UTC](https://community.easymorph.com/t/support-for-duckdb-done/5434/2 "2024-07-16T00:15:18Z")

</div>

Importing from DuckDB should work if you use the "Other SQL" dialect and the ODBC driver from DuckDB. Note that the "Other SQL" dialect only allows writing custom SQL queries. The visual query builder is not available for this dialect. Also, make sure you use the 64-bit ODBC driver, not the 32-bit one.

For other operations to work, such as export to DuckDB and creating tables, we should add support for the DuckDB SQL dialect. It won't work with the "Other SQL" dialect. Unless DuckDB's dialect is ANSI-compliant - in this case you can try using the ANSI:SQL dialect.

---

<div class="post-metadata">

**Author:** ![CTN](https://community.easymorph.com/letter_avatar_proxy/v4/letter/c/e19adc/32.png) [@CTN](https://community.easymorph.com/u/CTN)\
**Post date:** [July 16, 2024, 12:45am UTC](https://community.easymorph.com/t/support-for-duckdb-done/5434/3 "2024-07-16T00:45:18Z")

</div>

We see many advantages to supporting duckDB and the various extensions it provides. One extension that could really help Easymorph is the Spatial extension that supports GDAL and would allow reading/writing of gis files and enable spatial operations ie find all the records within 1km of a location. All using relatively straightforward SQL syntax

The ODBC driver is interesting in that you don’t actually need a file to read/write from. It can create an in memory virtual instance that can connect to a wide variety of data sources.

---

<div class="post-metadata">

**Author:** ![mattf](https://community.easymorph.com/user_avatar/community.easymorph.com/mattf/32/7015_2.png) [@mattf](https://community.easymorph.com/u/mattf)\
**Post date:** [October 20, 2026, 10:14am UTC](https://community.easymorph.com/t/support-for-duckdb-done/5434/4 "2026-10-20T10:14:08Z")

</div>

We added DuckDB support (including creating a new DuckDB file) in version 6.2. You can find more details here [What's New in EasyMorph v6.2 | EasyMorph](https://easymorph.com/blog/whats-new-in-easymorph-v62#DuckdbSupport)