Fix up and re-introduce Library v2 back-end work

[Pwuts]

• Fix up and re-introduce changes of feature(backend): Add ability to execute store agents without agent ownership #9179 and feature(platform): Implement library add, update, remove, archive functionality #9218 and feat(backend): Add Support for Managing Agent Presets with Pagination and Soft Delete #9211 (see Fix DB error: Could not find field at updateOneLibraryAgent.data.Agent.connect #9250)
• Finalizes Implement library add, update, remove, archive functionality #9167 and Implement Agent Preset Functionality #9168