async def METHOD_NAME(
    page: Optional[int] = None,
    page_size: Optional[int] = None,
) -> list[dict[str, Any]]:
    """Fetch many clans from the database."""
    query = f"""\
        SELECT {READ_PARAMS}
          FROM clans
    """
    params = {}
    if page is not None and page_size is not None:
        query += """\
            LIMIT :limit
           OFFSET :offset
        """
        params["limit"] = page_size
        params["offset"] = (page - 1) * page_size
    recs = await app.state.services.database.fetch_all(query, params)
    return [dict(rec) for rec in recs]