红移。我们如何(动态地)将表从列转置到行？

import sqlite3

# 连接到数据库
conn = sqlite3.connect('database.db')
cursor = conn.cursor()

# 创建新表
cursor.execute("CREATE TABLE transposed_table (column_name TEXT, value TEXT)")

# 查询原始表的列名
cursor.execute("PRAGMA table_info(original_table)")
columns = cursor.fetchall()

# 遍历原始表的每一行
cursor.execute("SELECT * FROM original_table")
rows = cursor.fetchall()

for row in rows:
    # 获取需要转置的列的值，并插入到新表的行中
    for column in columns:
        column_name = column[1]
        value = row[column_name]
        cursor.execute("INSERT INTO transposed_table (column_name, value) VALUES (?, ?)", (column_name, value))

# 提交事务并关闭连接
conn.commit()
conn.close()