[Local Testing] SNOW-1063738 Run all tests against Local Testing by default Part 1

[sfc-gh-stan]

This PR is a test only change that aims to run all tests against local testing by default. The changes are to

• xfail tests that don't apply to Local Testing, i.e. SQL feature tests like test_bind_variable.py
• skipif tests that need an additional feature support/a bug fix/some refactoring to be enabled in Local Testing.
• refactor some tests that use session.sql unnecessarily to run it against Local Testing

[sfc-gh-aling]

btw there is one change I made in my PR to turn create_stage/drop_stage into no-op for local testing, so that we can reduce some if-else check in the test code

    @staticmethod
    def create_stage(session: "Session", name: str, is_temporary: bool = True):
        if isinstance(session._conn, MockServerConnection):
            # no-op in local testing
            return
        session._run_query(
            f"create or replace {'temporary' if is_temporary else ''} stage {quote_name(name)}"
        )

    @staticmethod
    def drop_stage(session: "Session", name: str):
        if isinstance(session._conn, MockServerConnection):
            # no-op in local testing
            return
        session._run_query(f"drop stage if exists {quote_name(name)}")

[sfc-gh-stan]

Sounds good, if I merge later I will remove this if block.

[sfc-gh-aling]

minor: ditto on removing if not local_testing_mode: check

[sfc-gh-jrose]

I marked some of them, but there seems to be a lot of TODOs without ticket numbers.

[sfc-gh-stan]

I marked some of them, but there seems to be a lot of TODOs without ticket numbers.

This is a good point, I'll remove the TODOS for items that are not immediate TODOS, i.e. unsupported feature planned to be worked on later. I'll keep the TODOs for bug fixes and create tickets.