How can I export SQL query results to YAML format?

YAML is actually a superset of JSON, so anything that reads YAML will also handle JSON fine. You might be able to just load your JSON and let the YAML reader take it from there if you're stuck.

It's interesting that you're looking to use YAML! Just a heads up, it's pretty rare to find ingestion points that accept YAML. If you really need it for something specific, maybe consider using JSON instead, since YAML can be a bit finicky with quoted strings. There are several YAML modules you can find, just search for them in the PowerShell Gallery.

Thanks for sharing your use case! Since LLMs count every comma and brace, I really get why you're leaning towards YAML. Just make sure when you're converting, you check how each format is being read. Using the modules available seems like a solid move to ensure efficiency. Good luck!

I totally understand why you're looking for YAML over JSON for token count efficiency with LLMs. In that case, definitely check out some of those PowerShell YAML modules. You can use commands like ConvertFrom-Json and ConvertTo-Yaml to make the process easier. It sounds like you're up against a tough limit with those tokens!

Just a thought, but you might also consider exporting the SQL data to CSV as another option. YAML is more user-friendly for humans and DevOps, while JSON tends to be more suited for machine processing. Depending on your use case, CSV could be a lighter format as well.