Would be good to remove the 'id' of both User and Role schemas from what is dumped in REST API endpoints. ID of User and Role table are sensitive data that would be fine to hide from the endpoints

tests/api_connexion/endpoints/test_user_endpoint.py
"TEST_USER10",
                ],
            ),
            ("/api/v1/users?limit=1&offset=5", ["TEST_USER4"]),
            ("/api/v1/users?limit=1&offset=1", ["test_no_permissions"]),
            (
                "/api/v1/users?limit=2&offset=2",
                ["TEST_USER1", "TEST_USER2"],
            ),
        ]
    )
    def test_handle_limit_offset(self, url, expected_usernames):
        users = self._create_users(10)
        self.session.add_all(users)
        self.session.commit()
        response = self.client.get(url, environ_overrides={'REMOTE_USER': "test"})
        assert response.status_code == 200
        assert response.json["total_entries"] == 12
        usernames = [user["username"] for user in response.json["users"] if user]
        assert usernames == expected_usernames
    def test_should_respect_page_size_limit_default(self):
        users = self._create_users(200)
        self.session.add_all(users)
        self.session.commit()
        response = self.client.get("/api/v1/users", environ_overrides={'REMOTE_USER': "test"})
        assert response.status_code == 200
        
        assert response.json["total_entries"] == 200 + len(['test', 'test_no_permissions'])
        assert len(response.json["users"]) == 100
    def test_should_response_400_with_invalid_order_by(self):