在Sqlite3语句中使用变量的问题

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

query = "SELECT * FROM table_name WHERE column_name = ?"
value = "example_value"

cursor.execute(query, (value,))
result = cursor.fetchall()

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

query = "SELECT * FROM table_name WHERE column_name = :value"
params = {"value": "example_value"}

cursor.execute(query, params)
result = cursor.fetchall()