Convert STA directly to SQL

[filippofinke]

Currently, STA queries are being transformed into a format utilized by PostgREST. However, a limitation of this approach is that it restricts the extent of our interactions with the database.

To overcome this limitation, a more effective strategy could involve the implementation of a node visitor similar to the one already used to convert queries to PostgREST, as illustrated here:

istsos-miu/fastapi/app/sta2rest/sta2rest.py

Line 22 in 2c68537

class NodeVisitor(Visitor):

. This visitor would directly translate the AST tree of the STA query into SQL, thus alleviating the constraints posed by the existing method.