What things can you access/query with SQL apart from SQL servers?

1

Hello!

What things can you access/query with SQL apart from SQL servers?

For example, I think you can query Access db, but can you query things like:

  • xlsx or a table in xlsx?
  • json?
  • XML?
  • REST APIs?

I mean to write SQL like SELECT * from <<>> etc.

My goal is to query e.g. a REST API on the fly without having to download the whole JSON but also to leverage the popular SQL syntax to filter/query APIs, JSONs etc.

Thanks!

2

I think GraphQL is close to what you are asking about.

1 Like
3

You can do anything what is availiable in .NET, I'm not saying you should :slight_smile:

Common Language Runtime (CLR) Overview - SQL Server | Microsoft Learn

1 Like