Export queries filtering based on domain

[burrowse]

When exploring data in Ares, we observed a DQD failure for records in the procedure_occurrence table that did not belong to the "Procedure" domain. We attempted to view these concepts (e.g. 9202,581476 etc) in Ares but could not find them when we searched, despite being able to directly query the data for these records.

Upon further review, the exportToAres function references specific export queries for each table in the CDM. These queries are filtered for domain, thus excluding the offending records and obscuring the data quality issue from the Ares report. See example below for the procedure table:

Achilles/inst/sql/sql_server/export/procedure/sqlProcedureTable.sql

Line 15 in 247b86d

where domain_id = 'Procedure'

Perhaps the domain_id filter should be removed from these queries to allow the user to view the full characterization of the records in the respective table as opposed to filtering by domain.

This would be particularly important for the observation table which does not have domain_id restrictions, which is also currently being filtered in the export:

Achilles/inst/sql/sql_server/export/observation/sqlObservationTable.sql

Line 15 in 247b86d

where domain_id = 'Observation'