tharmigan/dbclient

function queryNativeSQL(ParameterizedQuery sqlQuery, typedesc<record {}> rowType) returns stream<rowType, Error?>

function executeNativeSQL(ParameterizedQuery sqlQuery) returns ExecutionResult|Error

function get appointments(AppointmentTargetType targetType, ParameterizedQuery whereClause, ParameterizedQuery orderByClause, ParameterizedQuery limitClause, ParameterizedQuery groupByClause) returns stream<targetType, Error?>

function get appointments/[int appointmentId](AppointmentTargetType targetType) returns targetType|Error

function post appointments(AppointmentInsert[] data) returns int[]|Error

function put appointments/[int appointmentId](AppointmentUpdate value) returns Appointment|Error

function delete appointments/[int appointmentId]() returns Appointment|Error

function get patients(PatientTargetType targetType, ParameterizedQuery whereClause, ParameterizedQuery orderByClause, ParameterizedQuery limitClause, ParameterizedQuery groupByClause) returns stream<targetType, Error?>

function get patients/[int id](PatientTargetType targetType) returns targetType|Error

function post patients(PatientInsert[] data) returns int[]|Error

function put patients/[int id](PatientUpdate value) returns Patient|Error

function delete patients/[int id]() returns Patient|Error

function close() returns Error?