Same #JupySQL Intro #JupyterBook 📓 markdown document in #VSCode IDE with the added top level Execute All, Select All, Extract All SQL code lenses, and Execute, Select, Copy and Create SQL code lenses in the code cells with %%sql #SQLMagics:

#MarkdownSQLProTools 🧙‍♂️ ...

All of our #ProDataTools 🛠️ are just $2.66 today with GitHub's prorated sponsorship tier pricing.

💖 https://github.com/sponsors/RandomFractals/sponsorships?tier_id=295482

Sign up today to get #DuckDBPro Tools, #PRQLProTools and our latest #MarkdownSQLProTools to query DuckDB and other data sources with #SQLTools in VS Code IDE like a Pro. More to come soon!

Using our soon to be released #MarkdownSQLPro Tools 🛠️ v1.2.0 in .Rmd docs:

1. Install #MarkdownSQLProTools:

🧐 https://github.com/RandomFractals/pro-data-tools#markdown-sql-pro-tools

2. Clone sql-in-rmd repository:

➤ https://github.com/sciencificity/sql-in-rmd

3. Open sql-in-rmd project and create new SQLite database connection.

4. Use Extract All code lens to extract all SQL code blocks.

5. Use Execute All code lens to run extracted SQL code.

6. Use Execute code lenses to execute individual SQL code blocks and view results.

#MarkdownSQL #ProDataTools 🧙‍♂️

#MarkdownSQLProTools v1.1.0 is now available to our sponsors on GitHub. This release adds new SQL Code Lenses to SQL code blocks in markdown documents and SQL statements in SQL documents.

🧐 ⤑ https://github.com/RandomFractals/pro-data-tools#markdown-sql-pro-tools

💖 + 💵 ⤑ 🛠️: https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=295482

#Markdown #SQL #ProDataTools 🧙‍♂️ ...

With #MarkdownSQLProTools v1.1.0 we plan to release to our sponsors on GitHub this week, you'll be able to run SQL code from code blocks in markdown documents and plain SQL documents & use different #SQLTools drivers, #DuckDBPro in this demo ... #ProDataTools 🧙‍♂️ ...

🧐 https://randomfractals.github.io/pro-data-tools/#markdown-sql-pro-tools

Wrapping up #DuckDBProTools update to support #DuckDB v0.8.0.

You'll be able to use it with our new #MarkdownSQLProTools we released this week to our sponsors on github.

& with new @evidence_dev @code starter kit we built recently.

#ProDataTools 🛠️ ...

https://marketplace.visualstudio.com/items?itemName=Evidence.evidence-vscode

📢 Happy to announce #MarkdownSQLProTools v1.0.0 release available to our sponsors on github:

💖 + 💵⤑ 🛠️ https://github.com/sponsors/RandomFractals/sponsorships?sponsor=RandomFractals&tier_id=295482

📥 https://github.com/RandomFractals/markdown-sql-pro-tools/releases/tag/v1.0.0

#SQLProTools / #ProDataTools 🧙‍♂️

Demo of our new #MarkdownSQLProTools extension with custom Select SQL & Execute SQL #VSCode lenses added to the #SQL code blocks in #markdown documents, showing SQL query results in #SQLTools + extended #DuckDB connection tree view display at the end using our #DuckDBProTools.

#DataTools 🧙‍♂️ ...

🥳 Behold! Our new #MarkdownSQLProTools extension w/Select SQL code & Execute All SQL statements #VSCode lenses, integrated with the popular #SQLTools extension & database drivers, #DuckDBProTools in this example 😎

#Markdown #SQL #DuckDB #ProDataTools #DataTools 🧙‍♂️ ... 💎💎💎... 🚀🚀🚀 !!!

well, we got most of it wired in a day. Will refine markdown code blocks parsing over the weekend and release new #MarkdownSQLProTools #VSCode extension to our Pro sponsors on github next week for sure. #dataTools 🧙‍♂️ ...

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 🔬 ...

Use our new $20/month #MarkdownSqlProTools subscription on GitHub to get invited to our new Markdown SQL Pro Tools for VS Code Preview next week:

💖 + 💰 = 🧙‍♂️ 🔬 🛠️ ⤑ https://github.com/sponsors/RandomFractals

#ProDataTools #ProSponsors ...

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 🔬 🧙‍♂️ ... 💎💎💎