And how it is actually stored and transmitted is not at all standard.

Well of course not, the whole point of the relational model is that you don't have to know...

The information_schema is an ansi standard for SQL metadata supported by every DBMS. So the format for representing SQL data is standard.

SQL is not a data format, it's s syntax for querying data.

You have perhaps heard of the DDL part of SQL?

I like no/low code tools, like Power BI and others.

Back on topic!

I am very impressed with what Microsoft have done with Power Query. They've put a lot of thought into...

There is no equivalent for a relational data set.

You have perhaps heard of SQL?

So once again I can say this data will be in JSON format and that is a common format that can be processed by any number of standard interfaces.

The proliferation...

I tried writing a linear regression function in Transact-SQL once. It was a lot of code - some of it necessarily dynamic. With R it is a single function -...

If you are doing anything statistical then R is the one to go for.

Python is a general purpose programming language. BASIC isn't dead, it's just called Python nowadays ;-).

Tabs aren't recognized, here are the hierarchies again:

Customer

----Order

--------Order Line

-----------Product

Product Group

-----Product

JSON is just JSON, any system that parses JSON can parse JSON, be that SQL Server, powershell or any other tool you might be using.

JSON has the fundamental problem of...

JSON or XML are supposed to be versatile(unlike older mainframe type hierarchies) and capable of being transmitted and consumed by a broad range of systems. Where as relational databases are...

The issue isn't so much that SQL server can't parse and format json it's that the data is represented in fundamentally different ways.

In which case why bother with JSON? Isn't...

I could have a container running PostGres, another running Python 3.7 with a bunch of libraries, Python 3.9 with a different set of libraries and versions of those libraries, a...

It would be very helpful to have a clear definition of what the term "container" means.

What is the difference between a container and a virtual machine?

I was persuaded to enter...

The proponents I've seen for low code/no code encourages allowing the "citizen developer" to write low code/no code applications. They are the domain experts. They understand the problem. Under normal...