Released #PRQLCodeLens v1.3.0 for #VSCode IDE with #PRQL v0.9.5 grammar support and updated PRQL and #DuckDB SQL query examples.
🧐 https://github.com/RandomFractals/prql-pro-tools
💖 https://github.com/sponsors/RandomFractals/sponsorships?tier_id=18884
#PRQLTools / #PRQLProTools / #PRODataTools 🧙♂️
Published our #PRQLTools #VSCode extension documentation for devs & data scientists interested in using #PRQL, #SQLTools and various DB drivers to check out:
📰 https://github.com/RandomFractals/pro-data-tools/blob/main/prql-tools.md
Quick demo of using ▶️ Run Query #PRQLCodeLens with our #DuckDB SQL Tools:
#ProDataTools 🛠️ 🧙♂️ ...
We'll be updating our #PRQLProTools / #PRQLCodeLens & #DuckDB #PRQL query examples for devs & data scientists using #SQLTools in #VSCode IDE this week. Stay tuned! ...
📰 https://github.com/RandomFractals/pro-data-tools#prql-pro-tools
🧐 https://twitter.com/search?q=%23PRQLProTools&src=typed_query&f=live
#SQL / #PRQL / #ProDataTools 🧙♂️ ...
We took the latest #AzureDataStudio for a spin today and can confirm that all of our old custom #VSCode #dataViz extensions work in that IDE, including new #DuckDB #SQLTools, #PRQLCodeLens, new #MarkdownSQL Tools, and soon to be released #DataNotebookPro 📚 Tools.
We'll post new walk-throughs on how to install and use some of those new #ProDataTools in Azure Data Studio IDE soon.
Let us know if any of these #DataTools would be of interest to your #DataTeams and users.
Our combined #ProDataTools 🛠️ changelog for the #DuckDB SQL and #DuckDBPro Tools, #PRQLCodeLens and #MarkdownSQLPro extensions, covering prominent features and enhancements in 15 releases of new #DataTools for VS Code IDE this year:
🥳 #PRQLProTools v1.2 & #PRQLCodeLens now use #PRQL language compiler v0.8 to generate & Run SQL queries for #DuckDB v0.8 & other #SQLTools DB drivers in #VSCode IDE.
See updated docs & become a Pro sponsor on github to access the latest #ProDataTools 🛠️ 🧙♂️ ...
Gonna scaffold our new #MarkdownSQLProTools #VSCode extension from #PRQLCodeLens code base as that extension already has #SQLTools, database connections, context, and query selection in text editor hookup for running SQL queries and displaying tabular data results.
#DataTools 🔬 ...
Yup! We'll create premium #DataProToolsPack for our github Pro sponsors & all the data sci majors & analysts out there using #VSCode.
This premium extensions pack will include our #DuckDBProTools, #PRQLCodeLens, new #DataQueryNotebooks 📚 & #MarkdownSqlProTools.
#DataTools 🔬 🧙♂️ ... 💎💎💎
You can try our advanced #DuckDBProTools & #PRQLCodeLens extension 📦s , additional examples & sample #DuckDB files by becoming a Pro sponsor & supporting our dev work on those extensions on github. Pro sponsors get collab access.
💖 https://github.com/sponsors/RandomFractals?o=sd&sc=t #ProDataTools 🛠️ ...
You can try our #DuckDBPro and #PRQLCodeLens Pro Tools free today. It's a one day deal! Don't miss out if you want to try the latest version of #DuckDB, #PRQL and #SQLTools in Code!
👉 https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
The official PRQL Code extension doesn't support #PRQL documents with multiple queries defined, but you'll be able to use our new #DataNotebooks 📚 extension to load such PRQL docs in #VSCode 📓 & run those queries inline or with #PRQLCodeLens & #DuckDBPro #SqlTools 🧙♂️ 🤯
willing data souls and explorers can try our awesome #PRQLCodeLens & #DuckDBProTools for $1.33 today. That #ProTools sub goes back to $10 tomorrow, as github prorates their monthly tiers and dues collected ... #PRQL #DuckDB #SQLTools 💎💎💎 ...
💵 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
#DataTools they don't cover at #DataCouncil23: #DuckDBProTools, #PRQLCodeLens, #DataNotebook 😎 ... #DataAnalytics 🧪 🧫 🔬 ...
Just having all that #DuckDB demo data to play with in #VSCode is probably worth $4.33 to get access to. idk, we'll see if it is. Besides, you do get slick #PRQLCodeLens ext. with it already. Will release the rest later this week. ✌️
💖 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
#DuckDBPro 💎💎💎
You can now Run #PRQL queries with new loop, func & let vars directly on the open #SQLTools connections using #PRQLCodeLens v1.1.0 extension from our private #PRQLPro Tools collection.
Sign up to get access to the PRQL Code Lens 📦 #DataTools:
💖 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
Where all the 🦆s at you ask?
Here is a fun #PRQL query you can run on that GBIF observations dataset 1st data chunk (~100MB) hosted by AWS with our #PRQLCodeLens #PRQLPro tool in VSCode 😎
See demo GIF on twitter: https://twitter.com/TarasNovak/status/1635632197422948352
Our #PRQLCodeLens users can run #PRQL queries directly on active #DuckDB SQLTools connections, without installing any extra unsigned DuckDB extensions, resorting to duckdb CLI or using Python duckdb tools.
In fact, they can do this with any of the supported PRQL target DB engines: https://prql-lang.org/book/language-features/target.html#supported-dialects
GIF: https://twitter.com/TarasNovak/status/1631999447147204608
#DataTools ...
🥳 Announcing our 1st #PRQLProTools release with #PRQLCodeLens to connect #PRQL directly to #SQLTools in #VSCode.
Become a Pro sponsor on github to get invited to this private #ProTools extension package repository:
💖 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
📥 ⤑ https://github.com/RandomFractals/prql-pro-tools
Wrapping up docs for the private beta #PRQLCodeLens release in our new #PRQLProTools repo that will host PRQL Run Query lens integrated w/#SQLTools in VSCode, #PRQLNotebooks 📚 & #PRQLTerminal extension for the CLI fans 👨💻 later ...
Sign up! 👉 https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=18884
Quick update on #DuckDBPro Tools private beta we plan to release next month:
✔️ New Sql Tools driver will be called DuckDBPro
✔️ Pro DB icons will have ▪️ in the ⚪️ & 🟡 DB state circles to make them look more like a 🦆 head 🙂
✔️ Pro Tools version will support DuckDB v0.7 and DB write
✔️ DuckDBPro Tools will work with our new Run Query #PRQLCodeLens
✔️ Private beta repository will have new demo employees.duckdb, and sample SQL and PRQL queries to run 👇
