View dataset public properties

[ElenaKhaustova]

Description

Users express the need to easily access datasets and examine their available public properties and methods.

We propose developing a method or functionality within the framework that allows users to retrieve datasets and view their public properties and methods in a structured and accessible manner.

It goes beyond redesigning DataCatalogAPI as requires modifications on the Dataset side.

Context

"I think once you've got the data set, it is useful to be able to look at any public property that's already there."

[ElenaKhaustova]

@astrojuanlu: "The most important philosophical question here is "opening up" the DataCatalog abstraction and make datasets first-class citizens, and not an implementation detail. This was mentioned as far back as 2022 #1778 (comment)"