Can it be considered that executing this query will not change the system state on repeated calls?

In the context of programming and databases, a query that does not change the state of the system when called repeatedly is called idempotent. For example, SQL queries like SELECT usually do not change the state and can be called multiple times without side effects.

To consider that executing a query will not change the system state upon repeated calls, it must be ensured that:

• The query does not contain data modification operators (INSERT, UPDATE, DELETE).
• The query does not invoke functions with side effects.
• The query does not depend on external states that may change.

If these conditions are met, the query can be considered safe for repeated execution without changing the system state.