Open jreuben11 opened 3 months ago
From Trino's own documentation: https://trino.io/docs/current/overview/use-cases.html
Do not mistake the fact that Trino understands SQL with it providing the features of a standard database. Trino is not a general-purpose relational database. It is not a replacement for databases like MySQL, PostgreSQL or Oracle. Trino was not designed to handle Online Transaction Processing (OLTP). This is also true for many other databases designed and optimized for data warehousing or analytics.
It's not a magical SQL translation layer. It's designed for analytics.
@abonander Trino is not a relational store, it is a distributed query engine that supports SQL syntax for analytics with push-down optimization of query plans to backing stores.
Trino is a distributed SQL engine which supports many backend connectors https://trino.io/ecosystem/data-source.html - if SQLx will support this, it will support everything see Prusto for a reference crate https://github.com/nooberfsh/prusto