INSERT without fields or values should result in a different SQL syntax

[akarelas]

• SQL::Abstract::Pg version: 1.0
• Perl version: v5.34
• Operating system: Ubuntu Linux 20.04

Steps to reproduce the behavior

When I do:

say $abstract->insert('a_table', {});

...I get:

INSERT INTO a_table VALUES ()

...which is invalid syntax in PostgreSQL v14 (results in error ERROR: syntax error at or near ")")

Expected behavior

The following SQL string should be output:

INSERT INTO a_table DEFAULT VALUES

[kraih]

Interesting idea.

[akarelas]

According to https://www.postgresql.org/docs/7.1/sql-insert.html, DEFAULT VALUES is supported all the way back to PostgreSQL v7.1.