`insertMany` does not work on tables that only have an "id" column

[tysonzero]

It generates the following:

INSERT INTO "table_name"() VALUES () RETURNING "id";

And the empty () is unfortunately not valid PostgreSQL.

[parsonsmatt]

Is there a corresponding SQL that does work?

[tysonzero]

At least in PostgreSQL the following works:

INSERT INTO "table_name"(id) VALUES (default), (default), (default) RETURNING "id";

[parsonsmatt]

Interesting! It might be good then to intentionally list fields that have defaults instead of implying them, and supplying a default keyword (if all backends support that?).