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

New Copy #SQL to clipboard Code Lens feature we'll ship in our #MarkdownSQLProTools v1.1.0 update next week for the #VSCode #SQLTools users sponsoring our Pro data tools work on GitHub ...

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

#MarkdownSQL #ProDataTools 🛠️🔬 ...

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