Repository: ploomber/jupysql (language: python)

Issue:
Sqlglot latest release breaking CI
Refer: https://github.com/ploomber/jupysql/actions/runs/7159082279/job/19491954937

Sqlglot >= 20.0.0 is causing the test to fail.


Discussion / hints:
@neelasha23 can you patch the version? this might be breaking for users so let's pin the version and then figure out a solution

Fix patch:
diff --git a/setup.py b/setup.py
index 2e1b87ad3..e1ba5911a 100644
--- a/setup.py
+++ b/setup.py
@@ -23,7 +23,7 @@
     "sqlparse",
     "ipython-genutils>=0.1.0",
     "jinja2",
-    "sqlglot>=11.3.7, <20.0.0",
+    "sqlglot>=11.3.7",
     "ploomber-core>=0.2.7",
     'importlib-metadata;python_version<"3.8"',
     "jupysql-plugin",


Test patch:
diff --git a/src/tests/test_connection.py b/src/tests/test_connection.py
index 1329eebca..9a9a0a399 100644
--- a/src/tests/test_connection.py
+++ b/src/tests/test_connection.py
@@ -196,7 +196,7 @@ def test_is_use_backtick_template_sqlglot_missing_tokenizer_AttributeError(
     conn = SQLAlchemyConnection(engine=create_engine("sqlite://"))
 
     monkeypatch.setattr(conn, "_get_sqlglot_dialect", lambda: "mysql")
-    monkeypatch.setattr(sqlglot.Dialect.get_or_raise("mysql"), "Tokenizer", None)
+    monkeypatch.setattr(sqlglot.dialects.mysql.MySQL, "Tokenizer", None)
 
     assert conn.is_use_backtick_template() is False