Bug: check_expired_rules probe has a SQL error

[ericvaandering]

Bug Description

Probably from the newest SQLAlchemy:

Traceback (most recent call last):
  File "/probes/common/check_expired_rules", line 37, in <module>
    result = session.execute(expired_rules).fetchone()[0]
  File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/orm/scoping.py", line 779, in execute
    return self._proxied.execute(
  File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/orm/session.py", line 2365, in execute
    return self._execute_internal(
  File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/orm/session.py", line 2149, in _execute_internal
    statement = coercions.expect(roles.StatementRole, statement)
  File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/sql/coercions.py", line 395, in expect
    resolved = impl._literal_coercion(
  File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/sql/coercions.py", line 621, in _literal_coercion
    return self._text_coercion(element, argname, **kw)
  File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/sql/coercions.py", line 614, in _text_coercion
    return _no_text_coercion(element, argname)
  File "/usr/local/lib64/python3.9/site-packages/sqlalchemy/sql/coercions.py", line 584, in _no_text_coercion
    raise exc_cls(
sqlalchemy.exc.ArgumentError: Textual SQL expression 'select count(1) from CMS_...' should be explicitly declared as text('select count(1) from CMS_...')

Reproduction Steps

No response

Expected Behavior

No response

Possible Solution

No response

Related Issues

No response