Skip to content

Add dialect support for DuckDB #18079

@elefeint

Description

@elefeint

Issue Creation Checklist

  • I understand that my issue will be automatically closed if I don't fill in the requested information
  • I have read the contribution guidelines

Feature Description

Implement dialect support for DuckDB / MotherDuck.

Describe the feature you'd like to see implemented

DuckDB is a popular in-process OLAP database. While ORM support is not a natural fit for OLAP query patterns generally, DuckDB/MotherDuck are also quite good at OLTP workloads. We also see customers migrating analytical workloads from transactional databases like Postgres -- it's a lot less work for them if they can keep using the same ORM library.

Describe why you would like this feature to be added to Sequelize

We've had a customer run in production with the old DuckDB Node library for more than a year now. I will contribute a rewrite based on the modern DuckDB Node Neo.

Is this feature dialect-specific?

  • No. This feature is relevant to Sequelize as a whole.
  • Yes. This feature only applies to the following dialect(s): DuckDB

Would you be willing to resolve this issue by submitting a Pull Request?

Very much so! The new dialect is written and passes all the tests. I'll be sending the companion pull request shortly.

  • Yes, I have the time and I know how to start.
  • Yes, I have the time but I will need guidance.
  • No, I don't have the time, but my company or I are supporting Sequelize through donations on OpenCollective.
  • No, I don't have the time, and I understand that I will need to wait until someone from the community or maintainers is interested in implementing my feature.

Indicate your interest in the addition of this feature by adding the 👍 reaction. Comments such as "+1" will be removed.

Metadata

Metadata

Assignees

No one assigned

    Labels

    pending-approvalBug reports that have not been verified yet, or feature requests that have not been accepted yet

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions