One schema. Every backend concern. Zero rewiring.

// Code generated by the zever DSL zenorm backend. DO NOT EDIT.
package app

import (
	"time"

	"github.com/zenta-dev/zever/orm"
)

// Tasks is the orm.Table for Task, generated from the "Task" entity.
var Tasks = orm.NewTable[Task]("tasks", []string{"id", "title", "done", "created_at"})

// TaskCols holds typed column references for Task.
var TaskCols = struct {
	ID        orm.Column[Task, string]
	Title     orm.Column[Task, string]
	Done      orm.Column[Task, bool]
	CreatedAt orm.Column[Task, time.Time]
}{
	ID:        orm.NewColumn[Task, string]("tasks", "id"),
	Title:     orm.NewColumn[Task, string]("tasks", "title"),
	Done:      orm.NewColumn[Task, bool]("tasks", "done"),
	CreatedAt: orm.NewColumn[Task, time.Time]("tasks", "created_at"),
}

// Task mirrors the "Task" entity declared in the schema.
type Task struct {
	ID        string    `json:"id"`
	Title     string    `json:"title"`
	Done      bool      `json:"done"`
	CreatedAt time.Time `json:"created_at"`
}

{
  "openapi": "3.0.3",
  "info": { "title": "zever API", "version": "0.0.0" },
  "paths": {
    "/v1/tasks": {
      "post": {
        "operationId": "TaskService_CreateTask",
        "requestBody": {
          "content": { "application/json": { "schema": { "$ref": "#/components/schemas/default_TaskServiceCreateTaskRequest" } } }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": { "application/json": { "schema": { "$ref": "#/components/schemas/default_Task" } } }
          }
        },
        "security": [{ "bearerAuth": [] }]
      },
      "get": {
        "operationId": "TaskService_ListTasks",
        "security": [{ "bearerAuth": [] }]
      }
    }
  }
}

table "tasks" {
  schema = schema.public
  column "id" {
    null = false
    type = uuid
  }
  column "title" {
    null = false
    type = varchar(200)
  }
  column "done" {
    null = false
    type = boolean
  }
  column "created_at" {
    null = false
    type = timestamptz
  }
  primary_key {
    columns = [column.id]
  }
}

// You write this. Zever resolved the pool.
func (s *TaskService) CreateTask(ctx context.Context, req *app.CreateTaskRequest) (*app.Task, error) {
	db, err := s.c.DB() // sqlite today, postgres by config
	if err != nil {
		return nil, err
	}
	t := &app.Task{ID: uuid.NewString(), Title: req.Title, CreatedAt: time.Now().UTC()}
	err = orm.InsertInto(app.Tasks).Values(
		orm.Set(app.TaskCols.ID, t.ID),
		orm.Set(app.TaskCols.Title, t.Title),
		orm.Set(app.TaskCols.Done, false),
		orm.Set(app.TaskCols.CreatedAt, t.CreatedAt),
	).Exec(ctx, db)
	return t, err
}

$ zever generate
wrote orm, openapi, atlas, routes
$ zever db migrate
applied schema.hcl
$ zever serve
listening on :8080
$ curl -X POST localhost:8080/v1/tasks -d '{"title":"ship"}'
{"id":"7c1e...","title":"ship","done":false}