In which property can you see the SQL query text?

In the query property of a cursor or connection object after executing a query.

Example with sqlite3:

import sqlite3

conn = sqlite3.connect(':memory:')
cursor = conn.cursor()

try:
    cursor.execute("SELECT 1")
    print(cursor.query) # In sqlite3, query is accessible on the cursor after execution
except AttributeError:
    print("query attribute is not available on the cursor in this library/version.")
finally:
    conn.close()

Example with psycopg2 (usually logged or accessible through database debugging tools, not always directly via the cursor property):

# In psycopg2, the query property may be available on the Cursor object,
# but is often used for debugging and logging at the database level
# or in special wrapper libraries.

# Example (may vary depending on version and configuration):
# import psycopg2
# conn = psycopg2.connect(...)
# cur = conn.cursor()
# cur.execute("SELECT * FROM users")
# print(cur.query) # If available

It is important to note that:

• The name and availability of the property may vary depending on the library (driver) used for database interaction (e.g., psycopg2, mysql-connector-python, sqlite3).
• Logging at the application or database level is often used for debugging and viewing queries.
• Some libraries may have a lastrowid property (identifier of the last inserted row), but not a property for the query text itself.

In general, if the library provides such a property, it is most often called query and is accessible on the object through which the query was executed (cursor or connection).