[DataCatalog2.0]: Make catalog CLI logic reusable across CLI and session

[ElenaKhaustova]

Description

Inconsistency between CLI commands and interactive workflow is a problem related to all kedro catalog commands. Currently, all CLI logic is implemented within commands and cannot be reused across the codebase. This is confusing for users as one cannot perform the same actions that are available via commands in the interactive workflow. It also requires additional maintenance as any catalog-related changes should be validated for CLI logic as well.

We suggest updating the catalog CLI logic with the current needs and KedroDataCatalog API and moving it to the session so it can be reused programmatically and via CLI.

Steps:

1. KedroDataCatalog CLI logic update [DataCatalog2.0]: Update KedroDataCatalog CLI logic and make it reusable #3312
2. Replace old CLI commands with new: [DataCatalog2.0]: Update catalog CLI commands based on reusable logic #4471