Python 목록을 SQL 쿼리에 효율적으로 통합하려면 어떻게 해야 합니까?

# Generate a string of IN values
in_values = ', '.join("?" * len(l))

# Substitute values into query
query = "SELECT name FROM students WHERE id IN (%s)" % in_values

# Execute query with list as parameter
cursor.execute(query, l)

# Use placeholders for each list element
placeholders = ['?' for _ in l]

# Format query with placeholders
query = "SELECT name FROM students WHERE id IN (%s)" % ', '.join(placeholders)

# Bind list as parameters
cursor.execute(query, l)

# Join with a table derived from the list
aux_table = pd.DataFrame({'id': l})
result = pd.read_sql_query("SELECT * FROM students JOIN aux_table ON students.id = aux_table.id", con)