Inserting multiple values in a row

报告提到了 asyncpg、PostgreSQL 15.4、Python 和一条 INSERT 语句，但没有指出任何 repository 文件或测试。首先检查 asyncpg 文档中记录的 INSERT 参数处理方式，并结合 PostgreSQL 语法进行对照；只有在获得 maintainer 确认的答案，或完成一项范围明确且附带回归测试的改动后，才能算完成。

• asyncpg version: 0.29.0
• PostgreSQL version: 15.4
• Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
  the issue with a local PostgreSQL install?: No
• Python version: 3,8,9
• Platform: Windows 7
• Do you use pgbouncer?: No
• Did you install asyncpg with pip?: Yes
• If you built asyncpg locally, which version of Cython did you use?: None
• Can the issue be reproduced under both asyncio and
  uvloop?: No

Hello.
I'm migrating from psycopg2 to asyncpg and I still don't understand much and have questions.
Sorry if they are stupid :)

To fill all the cells in a row in psycopg2 I specified:

"""INSERT INTO table_name VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);""",
                (
                    "here is a list of data"
                )

For the same operation in asyncpg I need to specify the names of all columns, i.e. the code is twice as large.
Is this the only correct solution?

"""INSERT INTO table_name
                 (
                    "here is a list of column names"
                 )
                 VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15);""",
                (
                    "here is a list of data"
                )