Skip to content

0.3.0
Compare
Choose a tag to compare
@julien040 julien040 released this 20 Nov 15:33
· 44 commits to main since this release
0.3.0
bbf350e

What is Anyquery?

Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.

It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.

Get started at anyquery.dev

Anyquery

Changelog

Database querying

Anyquery now supports database querying. You can join data between APIs, local files, apps, and now SQL databases.
At the moment, we support PostgreSQL-wire and MySQL-wire compatible databases.

Fixes

There are a lot of fixes that have been made. Feel free to open an issue if you find any new bugs.

Breaking changes

  • To work with PRQL, PRQL now needs to be installed on your machine and available in the PATH.
  • The Anyquery's SQL parser has changed, which means that there might be undiscovered issues.
  • When you query from a remote file, the cache can now be invalidated.
  • Anyquery cannot be installed with snapcraft anymore due to confinement issues.

Commits

  • 00b9fb3 ✅ Remove failing test for plugin loading
  • 1311a60 ✅ Update weird failing test
  • b322d10 ✨ Add ClickUp plugin
  • 5d39397 ✨ Add Coda plugin
  • 8e56cd0 ✨ Add PostgreSQL db querying
  • 50524ef ✨ Add SQLite version to -v flag
  • e263e2f ✨ Add Salesforce custom plugin
  • c2247a7 ✨ Add Salesforce plugin
  • 4bc37c9 ✨ Add hashing function for query constraint
  • afed809 ✨ Add hubspot plugin
  • 4abdd6e ✨ Add new SQL date functions
  • 0e07a11 ✨ Add new type conversion for plugin configuration
  • c632b6c ✨ Add search bar to website
  • a8be1f1 ✨ Add stanchion plugin
  • eb9dce5 ✨ Add support for MySQL-based databases
  • 8937e50 ✨ Add support for additionnal types
  • 1fc1da7 ✨ Modify the release header to include a SQL snippet
  • 347bb68 ✨ Update website to document databases connections
  • e2d412c ➖ Ditch pg_query parser for SQL query
  • 2844256 ⬆️ Run go mod tidy
  • ea4deec ⬆️ Run go mod tidy and update vitess lib
  • bc9b932 ⬆️ Update SQLite to v3.47.0
  • d1798da ⬆️ Upgrade dependencies to latest version
  • e4797ba 🐛 Fix DESCRIBE table_name queries on composite PK
  • 53861ec 🐛 Fix issue in goreleaser template Tabs instead of spaces...
  • 3d0fb0e 🐛 Fix issue with argument type for Salesforce plugin
  • 49f201d 🐛 Fix pull request query
  • a6399aa 🐛 Fix weird cache invalidation bug for the query hub
  • 1de3cec 🐛 Proper data validation for profile creation
  • 9d01809 🐛 SQLparser quoting issue Ensure that if a single quote was encountered in a string literal, the formatter would return '' to escape it. Before, it would attempt to write ', which is MySQL specifix syntax.
  • bbf350e 👷 Remove snapcraft publishing
  • dc37f1f 💄 A few UI updates to the website
  • 725af31 💄 Larger tables for terminal output
  • 0be92c0 💄 Update header image
  • 1ad6de1 📝 Add more docs for query hub
  • 7a269a1 📝 Remove snapcraft tutorial while snap issues aren't fixed
  • c84be1b 📝 Update README.md to talk about databases
  • fab1995 📦️ Move snapcraft to classic confinement
  • 10d0933 📦️ Update name format to a namespace based one (thanks @asg017)
  • 925ecf7 🔍️ Update SEO desc
  • 86e215a 🔥 Remove statical linking of PRQL
  • f7b881a 🚑️ Add support for non public schema tables in PostgreSQL
  • 0e866ef 🚸 Registry refreshes every two days now

Contributors

asg017
Assets 16
Loading