在 Python 中操作数据库结果集的最佳实践？

from sqlalchemy import create_engine

engine = create_engine('sqlite:///db.sqlite3')

# 查询示例
results = engine.execute("SELECT * FROM my_table")

from sqlalchemy.dialects import sqlite

cursor = engine.execute("SELECT * FROM my_table")
int_results = cursor.fetchall()
name_results = cursor.fetchone()

# 查询示例，仅获取第一个结果
name_results = cursor.fetchone()

# 查询示例，仅获取所有结果，并使用 `ORDER BY` 指令按降序排序
results = cursor.fetchall()
filtered_results = results.order_by(-results.c.column_key).fetch(10)

len(results) == 10  # True

name = cursor.fetchone()
name.startswith("Alice")  # True/False