MarySC , Good day 🙂
Here's an example demonstrating how to use the user.list() method
from models import User
import catalogs
user = User()
(Get SQL query for all users)
query_str = user.list()
(Get SQL query retrieving only specified fields)
query_str = user.list(only=["Id", "Inviter", "InviterUser"])
(Get SQL query adding another filter)
query_str = user.list(only=["Id", "Inviter", "InviterUser"], filters={"InviterUserCatalog": None, "Inviter": (None,)})
query = catalogs.query(query_str)
item["query_result"] = query.execute()