⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { sql } from "drizzle-orm";
import { columnTable, taskTable } from "../database/schema";
// Completion belongs to the task's workflow, even when its parent is elsewhere.
export const taskIsCompleted = sql<boolean>`exists (
select 1 from ${columnTable}
where ${columnTable.projectId} = ${taskTable.projectId}
and ${columnTable.slug} = ${taskTable.status}
and ${columnTable.isFinal} = true
)`;