const char *query_html_post = \
"SELECT id, title, created_at::DATE, body "
"FROM posts "
"WHERE id = $1;";
const char *query_html_posts = \
"SELECT id, title, created_at::DATE, body "
"FROM posts "
"ORDER BY updated_at DESC;";
const char *query_json_post = \
"SELECT JSON_AGG(ROW_TO_JSON(row)) FROM ("
"SELECT id, title, body, created_at, updated_at "
"FROM posts "
"WHERE id = $1"
") row;";
const char *query_json_posts = \
"SELECT JSON_AGG(ROW_TO_JSON(row)) FROM ("
"SELECT id, title, body, created_at, updated_at "
"FROM posts "
"ORDER BY updated_at DESC"
") row;";