fix: support returning when insert with no columns in sqlite

taozhi8833998 · taozhi8833998 · commit 2b49e169d8e5 · 2026-01-06T14:06:13.000+08:00
diff --git a/pegjs/sqlite.pegjs b/pegjs/sqlite.pegjs
@@ -1891,7 +1891,8 @@ insert_no_columns_stmt
     t:table_name  __
     p:insert_partition? __
     v:insert_value_clause __
-    odp: on_duplicate_update_stmt? {
+    odp: on_duplicate_update_stmt? __
+    r:returning_stmt? {
       if (t) {
         tableList.add(`insert::${t.db}::${t.table}`)
         columnList.add(`insert::${t.table}::(.*)`);
@@ -1909,6 +1910,7 @@ insert_no_columns_stmt
           partition: p,
           prefix,
           on_duplicate_update: odp,
+          returning: r,
         }
       };
     }
diff --git a/test/sqlite.spec.js b/test/sqlite.spec.js
@@ -235,12 +235,16 @@ describe('sqlite', () => {
   })
 
   it('should support INSERT ... RETURNING *', () => {
-    const sql = `INSERT INTO users (email) VALUES (?) RETURNING *`
+    let sql = `INSERT INTO users (email) VALUES (?) RETURNING *`
     expect(getParsedSql(sql)).to.be.equal(`INSERT INTO "users" (email) VALUES (?) RETURNING *`)
+    sql = `INSERT INTO users VALUES (2, "example", "example@example.com") RETURNING *;`
+    expect(getParsedSql(sql)).to.be.equal(`INSERT INTO "users" VALUES (2,"example","example@example.com") RETURNING *`)
   })
   it('should support INSERT ... RETURNING specific columns', () => {
-    const sql = `INSERT INTO users (email) VALUES (?) RETURNING id, email as email_address`
+    let sql = `INSERT INTO users (email) VALUES (?) RETURNING id, email as email_address`
     expect(getParsedSql(sql)).to.be.equal(`INSERT INTO "users" (email) VALUES (?) RETURNING "id", "email" AS "email_address"`)
+    sql = `INSERT INTO users VALUES (2, "example", "example@example.com") RETURNING id, email;`
+    expect(getParsedSql(sql)).to.be.equal(`INSERT INTO "users" VALUES (2,"example","example@example.com") RETURNING "id", "email"`)
   })
   it('should support UPDATE ... RETURNING *', () => {
     const sql = `UPDATE users SET email = ? RETURNING *`
