Add new REST endpoints that mirror existing sql queries and replace existing sql query with REST
Specifically: Convert "query_cyhy_assets()" TSQL query to an API endpoint
Motivation and context
There are two major reasons to use endpoints in place of sql queries.
Replace the need to know t-sql
Off load data aggregation to fastapi parallel workers
Implementation notes
Gather existing queries from code.
Create new endpoints at fastapi.
Secure new endpoints in same fashion as existing endpoint.
💡 Summary
Add new REST endpoints that mirror existing sql queries and replace existing sql query with REST Specifically: Convert "query_cyhy_assets()" TSQL query to an API endpoint
Motivation and context
There are two major reasons to use endpoints in place of sql queries.
Implementation notes
Acceptance criteria