Create SQL Query

[lizkrznarich]

Create a SQL query (or set of queries) for the Corpus DB that retrieves fields needed for the JSON representation of citation records described in Corpus file v1.1 Technical spec.

• Some fields from the assertions table should not be included (per the spec)
• UUIDs in the assertions table should be replaced with corresponding strings or JSON objects

Example JSON record:

{   
"id":"cdfe1599-7288-4fbd-b8d8-4a25fb6d170d",
"created":"2023-09-26T10:26:21.549Z",
"updated":"2023-11-15T23:17:25.755Z",
"repository":"European Nucleotide Archive",
"publisher":"F1000 Research Ltd",
"journal":"Wellcome Open Research",
"title":null,
"objId":"10.12688/wellcomeopenres.17706.1",
"subjId":"OU744360.1",
"publishedDate":"2022-02-15T00:00:00.000Z",
"accessionNumber":"OU744360.1",
"doi":null,
"relationTypeId":null,
"source":"czi",
"subjects":[],
"affiliations":[],
"funders":[]
}