NpgsqlRestAutomatic PostgreSQL Web Server

-- REST endpoint with custom path and authentication
create function api.get_user(p_id int)
returns setof user_info as $$
select id, name, email, role from users where id = p_id;
$$ language sql;

comment on function api.get_user(int) is '
HTTP GET /users/{p_id}
@authorize admin, user
@cached
@cache_expires_in 300
@rate_limiter_policy standard
';

-- Server-Sent Events for real-time updates
comment on function live_notifications() is '
HTTP
@sse
';

-- File upload with validation
comment on function upload_image(json) is '
HTTP POST
@upload for file_system
@param _meta is upload metadata
@included_mime_types = image/*
';

-- Rate-limited public API
comment on function search(text) is '
HTTP GET /search
@allow_anonymous
@rate_limiter_policy fixed
@validate _query using required
';