[FEATURE]: Add an SQLite implementation of the Local Secrets Manager

[strickvl]

Contact Details [Optional]

[email protected]

Describe the feature you'd like

ZenML currently offers a file-based local secrets manager (found at zenml/src/zenml/secrets_managers/local/local_secrets_manager.py).

It would be good to have an SQLite implementation of the same behaviours, where secrets were stored locally inside a database.

Generally ZenML likes to use SQLModel for its use of SQL databases and the dependency is already available.

Is your feature request related to a problem?

No response

How do you solve your current problem with the current status-quo of ZenML?

The current local secrets manager is implemented as a local file-based store.

Any other comments?

This relates to #ENG-716 (Jira).