Not OP but I reckon OP would have XML documents from which to generate SQL schema and queries, with one XSL for generating schema, and one or more XSLs for gene

Not OP but I reckon OP would have XML documents from which to generate SQL schema and queries, with one XSL for generating schema, and one or more XSLs for generating queries. You could do the same with jq.