[PDB-1520] Use subselect for row_to_json so we don't have to rename keys Created: 2015/05/13  Updated: 2015/07/10  Resolved: 2015/05/15

Status: Closed
Project: PuppetDB
Component/s: None
Affects Version/s: None
Fix Version/s: PDB 3.0.0

Type: Improvement Priority: Normal
Reporter: AJ Roetker Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Template:
Story Points: 2
Sprint: PuppetDB 2015-05-20

 Description   

As described in http://hashrocket.com/blog/posts/faster-json-generation-with-postgresql we can (and probably should) use subselects to generate responses via the row_to_json in the query-recs in the query-engine which have proper key name so that we don't need to rename keys in clojure code, e.g. `f1` -> `hash`.


Generated at Thu Feb 27 00:52:28 PST 2020 using JIRA 7.7.1#77002-sha1:e75ca93d5574d9409c0630b81c894d9065296414.