Remove silent downcasting from API method and refactor tests

[javihern98]

Overview

Issue #71 reduces the range of Pandas libraries used to 2.1.4-2.2 to ensure we can use the engine with APT packages. This change generated an exception related to the silent downcasting we use before visiting the interpreter, using both semantic analysis and run methods on API:

    with pd.option_context("future.no_silent_downcasting", True):
        result = interpreter.visit(ast)

When attempting to remove the silent downcasting, I find there is some issue in test 5 of the CASE tests (test_case_ds, parameter 5)

Important

When solving this issue, double check you have installed pandas 2.1.4

Tasks to perform

• Ensure all tests are using API methods run and semantic_analysis
• Ensure all tests are working fine when removing the silent downcasting

Note

No tests should be added for this issue