Method test_sql_native_query_01

tests/test_sql_query.py:3043–3069

(self)

        )

    async def test_sql_native_query_01(self):
        await self.assert_sql_query_result(
            """
                SELECT
                    "Movie".title,
                    "Genre".name AS genre
                FROM
                    "Movie",
                    "Genre"
                WHERE
                    "Movie".genre_id = "Genre".id
                    AND "Genre".name = 'Drama'
                ORDER BY
                    title
            """,
            [
                {
                    "title": "Forrest Gump",
                    "genre": "Drama",
                },
                {
                    "title": "Saving Private Ryan",
                    "genre": "Drama",
                },
            ],
            apply_access_policies=False,
        )

    async def test_sql_native_query_02(self):
        await self.assert_sql_query_result(