Bulk inserts using unnest

juanluispaz / ts-sql-query

Type-safe SQL query builder like QueryDSL or JOOQ in Java or Linq in .Net for TypeScript with MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer support.

https://ts-sql-query.readthedocs.io/

MIT License

291 stars 19 forks source link

Bulk inserts using unnest #119

Open DGCarramona opened 7 months ago

DGCarramona commented 7 months ago

Hello, Given PostgreSQL has a limit of 65535 params in prepared queries, do you have any plans to implement something like described in this blog post ? https://klotzandrew.com/blog/postgres-passing-65535-parameter-limit

juanluispaz commented 7 months ago

Hi!

I'm preparing version 2 of ts-SQL-query, and I want to address this kind of thing.

This point had been on my list for changes in the generated SQL.

Can you share any other related information, including for other databases? that will be useful.

DGCarramona commented 7 months ago

Sorry, I work only with PostgreSQL, so I will not be able to provide information for other databases. But if you have any question regarding this subject, I would be glad to provide all the help I can.