# \#sql

**URL:** https://ask.cyberinfrastructure.org/tag/sql/286.md

[Latest](https://ask.cyberinfrastructure.org/latest.md) · [Categories](https://ask.cyberinfrastructure.org/categories.md) · [Tags](https://ask.cyberinfrastructure.org/tags.md)

---

## [Database Specialist - Remote - Office of Research Information Systems (ORIS)](https://ask.cyberinfrastructure.org/t/database-specialist-remote-office-of-research-information-systems-oris/2463)

<div class="topic-metadata">

**Author:** [@ashstauff](https://ask.cyberinfrastructure.org/u/ashstauff)\
**Replies:** 0\
**Last updated:** [August 22, 2022, 3:37pm UTC](https://ask.cyberinfrastructure.org/t/database-specialist-remote-office-of-research-information-systems-oris/2463 "2022-08-22T15:37:14Z")

</div>

Apply and see additional position details here: Database Specialist The ORIS team is integral for the execution of research at Penn State. They are an agile software dev shop with some excellent scrum masters, biz analy…

---

## [Going between XML (or JSON) and table-like formats](https://ask.cyberinfrastructure.org/t/going-between-xml-or-json-and-table-like-formats/1547)

<div class="topic-metadata">

**Author:** [@jpessin1](https://ask.cyberinfrastructure.org/u/jpessin1)\
**Replies:** 3\
**Last updated:** [November 17, 2020, 4:42pm UTC](https://ask.cyberinfrastructure.org/t/going-between-xml-or-json-and-table-like-formats/1547 "2020-11-17T16:42:31Z")

</div>

Are there any good SQL or other table based methods to support the variability in XML/JSON data? When is there a standard way to flatten this for tabular work? As a simple example illustration, NCBI database are access…