Migrate pipelines queries to Drizzle

[dinmukhamedm]

Migrate get pipelines, create pipeline, rename pipeline, delete pipeline, update pipeline version, commit pipeline version, set target pipeline, etc. from app-server (routes/pipelines.rs and db/pipelines/*) directly to calling drizzle from the next routes in /api/projects/[projectId]/pipelines.

Be careful not to remove some db queries that are used by other parts of backend, e.g. get pipeline version graph for pipeline run requests.

hi @dinmukhamedm could you please assign this issue to me?