add htsql endpoint; extend resource endpoint wi2th expanded JSON