The explosive growth in data has led companies to adopt common formats such as XML and JSON to manage this data. Despite its popularity, JSON presents a challenge when ingested into relational databases due to its unstructured nature. This is where tools like jq come in handy, which can transform, extract, filter, and change the structure of JSON data completely. SingleStore has integrated jq as a native JSON transformer, providing users with a performant and easy-to-use solution to handle one of the most common data formats today. By leveraging features in jq, companies can ingest and process large amounts of unstructured JSON data from platforms like CloudTrail without needing extra tools, allowing them to reap the benefits of both structured and unstructured data paradigms.