0.46.0 - Release - Fix path traversal bug for sqlite, new clickhouse options, and support for OpenAI-like URLs

__ Generated By Clidey's Auto GitHub Release__

✨ Improvements

Added new clickhouse options for HTTP

• Thanks to the contribution by @Slach, we've got additional options for clickhouse support, HTTP protocol, TLS mode, readonly and debug.

Support for OpenAI-like URLs

• Thanks to the contribution by @learningpro, we support OpenAI-like URLs now. Check the readme to see how to get started!

Support for env variable aliases

• #323

Replaced the Monaco Editor with Codemirror

• Makes the frontend lighter and is completely packaged.

Added loading indicators in several places to provide visual feedback to the user

• #75

🐛 Bug Fixes

Path traversal issue for sqlite

• Resolved an issue with how the database location for sqlite was being parsed resulting in the possibility of path traversal. Thanks to @nnse for catching that one!

Parameter injection issue for MySQL

• Resolved an issue where it was possible to inject parameters using the UI. Alongside this, we took the time to go through all of the other connectors and check how we're handling input. Please let us know if you find anything out of place! Thanks to @nnse for catching that one!

Unique table IDs for columns with the same name

• #316

Tables have correct # index number when paginating

---

Thank you to everyone who contributed to this release! 🚀
Your feedback and support are invaluable.

What's Changed

• add additional options for clickhouse support by @Slach in #300
• Add OpenAI Compatible Provider by @learningpro in #252
• Add Alias logic by @hkdeman in #331
• Ensure ids are unique for columns with same name by @hkdeman in #332
• Replace monaco editor with code mirror by @hkdeman in #333
• Add loading states by @hkdeman in #336

New Contributors

• @Slach made their first contribution in #300

Full Changelog: 0.45.0...0.46.0