使用sqlalchemy connection.execute

sql = text("SELECT users.fullname || ', ' || addresses.email_address AS title FROM users, addresses WHERE users.id = addresses.user_id AND users.name BETWEEN :x AND :y AND (addresses.email_address LIKE :e1 OR addresses.email_address LIKE ：e2）”）將命名參數傳遞到execute（）函數：

Benefits of Named Parameters

1. Reduced Risk of SQL Injections:

   sql = text("SELECT users.fullname || ', ' || addresses.email_address AS title FROM users, addresses WHERE users.id = addresses.user_id AND users.name BETWEEN :x AND :y AND (addresses.email_address LIKE :e1 OR addresses.email_address LIKE :e2)")

   改進的代碼可讀性：
名為參數使代碼更易讀，更易於理解，尤其是在處理複雜的查詢時，涉及涉及多個參數的複雜查詢。方法
2. 也可以定義一個函數來包裝execute函數並接受命名parameters作為字典：

   連接= Engine.connect（） 嘗試： 行= Connection.execute（sql，values） ... 最後： Connection.Close（） 返回結果

   在此方法中，可以通過以下方式執行查詢：

   conn.execute(sql, {"x": "m", "y": "z", "e1": "%@aol.com", "e2": "%@msn.com"})

   此方法在維護原始代碼的核心功能時啟用了命名參數的利用。