Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
The only wrinkle is that we can't support upserts for SQL Server yet because knex does not have support for it. There's a PR open adding support for it that has some recent activity, so perhaps this will be something we can enable in the near future: https://github.com/knex/knex/pull/6050.
Description
This is the backend half of https://linear.app/budibase/issue/BUDI-8220/support-updating-existing-rows-for-external-databases-using-csv-import. It adds backend support for doing bulk imports of rows, supporting upserts against keys that already exist.
The only wrinkle is that we can't support upserts for SQL Server yet because
knex
does not have support for it. There's a PR open adding support for it that has some recent activity, so perhaps this will be something we can enable in the near future: https://github.com/knex/knex/pull/6050.