3 ms·
> What do you mean by "standard" SQL? No extensions, just the default Postgres Cloud SQL offering from Google Cloud. > Also, what makes BigQuery not a "standa
by bhouston 2y ago
> What do you mean by "standard" SQL?
No extensions, just the default Postgres Cloud SQL offering from Google Cloud.
> Also, what makes BigQuery not a "standard SQL database" -- they use GoogleSQL, true, but many DBs have slight SQL variants.
I view BigQuery as not a standard DB because it really doesn't do transactions, rollbacks, foreign key constraints, indices, stored procedures, etc. I view it as a non-SQL database pretending to be SQL for query convenience.
- gbin 2y agoI think you mean a relational database.
- layer8 2y agoAll the features mentioned are part of SQL.
- nom 2y agoSQL is a language to interact with a relational database. It is not about the language.
- jandrewrogers 2y agoSQL (the DML) is just a query language. It could be implemented on anything. Parts of SQL DDL is implementation specific. The SQL standard hardcodes the assumption of (by modern standards) a small-scale system and therefore will deviate significantly on large-scale systems. There is no practical way to make this "standard", you have to understand the implementation it reflects.