📦 aura/sqlquery 7.0.0-beta2
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
October 19, 2026 at 3:00 AM
📦 aura/sqlquery 7.0.0-beta2
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
📦 aura/sqlquery 7.0.0-beta1
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
September 30, 2026 at 6:38 AM
📦 aura/sqlquery 7.0.0-beta1
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
🔗 https://github.com/auraphp/Aura.SqlQuery
September 9, 2026 at 9:16 AM
I'm poking away at something that looks closer to what I'd prefer. Looking nicer than SqlObject; Python gives you runtime access to parameter names:
@SqlQuery([snip])
def get(self, id: int, active: bool) -> Record
vs
@SqlQuery([snip])
Record get(@Bind("id") int id, @Bind("active") boolean active)
@SqlQuery([snip])
def get(self, id: int, active: bool) -> Record
vs
@SqlQuery([snip])
Record get(@Bind("id") int id, @Bind("active") boolean active)
August 31, 2026 at 11:58 AM
I'm poking away at something that looks closer to what I'd prefer. Looking nicer than SqlObject; Python gives you runtime access to parameter names:
@SqlQuery([snip])
def get(self, id: int, active: bool) -> Record
vs
@SqlQuery([snip])
Record get(@Bind("id") int id, @Bind("active") boolean active)
@SqlQuery([snip])
def get(self, id: int, active: bool) -> Record
vs
@SqlQuery([snip])
Record get(@Bind("id") int id, @Bind("active") boolean active)
Clean and merge your AI-extracted data instantly with in-memory SQL processing. Fast, free, and incredibly powerful. 🚀💻 #DataCleaning #SQLQuery
matasoft.hr/qtrendcontro...
matasoft.hr/qtrendcontro...
August 25, 2026 at 7:54 AM
Clean and merge your AI-extracted data instantly with in-memory SQL processing. Fast, free, and incredibly powerful. 🚀💻 #DataCleaning #SQLQuery
matasoft.hr/qtrendcontro...
matasoft.hr/qtrendcontro...
Watch now: zurl.co/EPiu3
How to Query Non-Openers Using Sent & Open Data Views in Salesforce Marketing Cloud
#SalesforceMarketingCloud #SFMC #DataViews #SQLQuery #EmailMarketing #NonOpeners #SentDataView #OpenDataView #MarketingCloud #EmailAutomation #Salesforce #SFMCTraining
How to Query Non-Openers Using Sent & Open Data Views in Salesforce Marketing Cloud
#SalesforceMarketingCloud #SFMC #DataViews #SQLQuery #EmailMarketing #NonOpeners #SentDataView #OpenDataView #MarketingCloud #EmailAutomation #Salesforce #SFMCTraining
How to Query Non-Openers Using Sent & Open Data Views in Salesforce Marketing Cloud
Want to identify subscribers who received your email but didn’t open it? 📧 In this video, learn how to query non-openers using the Sent and Open Data Views ...
www.youtube.com
August 20, 2026 at 10:26 AM
Watch now: zurl.co/EPiu3
How to Query Non-Openers Using Sent & Open Data Views in Salesforce Marketing Cloud
#SalesforceMarketingCloud #SFMC #DataViews #SQLQuery #EmailMarketing #NonOpeners #SentDataView #OpenDataView #MarketingCloud #EmailAutomation #Salesforce #SFMCTraining
How to Query Non-Openers Using Sent & Open Data Views in Salesforce Marketing Cloud
#SalesforceMarketingCloud #SFMC #DataViews #SQLQuery #EmailMarketing #NonOpeners #SentDataView #OpenDataView #MarketingCloud #EmailAutomation #Salesforce #SFMCTraining
Looks like it's this one (perhaps among many) github.com/microsoft/Ty...
[bug] TemplateStringsArray is incompatible with literal array type · Issue #16552 · microsoft/TypeScript
TypeScript Version: 2.4.0 Code // A *self-contained* demonstration of the problem follows... interface SQLQuery<TResult> { __result: TResult; } declare function sql( literals: ['SELECT id FROM user...
github.com
January 18, 2025 at 6:55 AM
Looks like it's this one (perhaps among many) github.com/microsoft/Ty...
This also lets you build up complex queries from fragments of SQL because we can tell the difference between an SQLQuery value and a raw string/object.
April 13, 2026 at 8:04 AM
This also lets you build up complex queries from fragments of SQL because we can tell the difference between an SQLQuery value and a raw string/object.
That’s awesome. It’s the same approach (broadly speaking) that I take in www.atdatabases.org/docs/sql - by using a class of SQLQuery for the result of the tagged templates, I can ensure both with TypeScript and at runtime that you don’t accidentally pass raw strings as db queries.
Building SQL Queries
All SQL Databases in @databases use the same approach for building SQL Queries. Using tagged template literals gives you a powerful and flexible way of creating queries without opening yourself to SQL...
www.atdatabases.org
April 13, 2026 at 8:02 AM
That’s awesome. It’s the same approach (broadly speaking) that I take in www.atdatabases.org/docs/sql - by using a class of SQLQuery for the result of the tagged templates, I can ensure both with TypeScript and at runtime that you don’t accidentally pass raw strings as db queries.
I'm feeling the same way RStudio ...
allbookings = data.frame(sqlQuery(conn, q1))
Error: memory exhausted
allbookings = data.frame(sqlQuery(conn, q1))
Error: memory exhausted
February 20, 2026 at 5:34 AM
I'm feeling the same way RStudio ...
allbookings = data.frame(sqlQuery(conn, q1))
Error: memory exhausted
allbookings = data.frame(sqlQuery(conn, q1))
Error: memory exhausted
SQL Queries for Make, Model and Architectures of Devices | #Guide #SystemCenter #SQL #SQLQuery #Database #DataEngineering #DeviceManagement
April 9, 2026 at 1:09 AM
SQL Queries for Make, Model and Architectures of Devices | #Guide #SystemCenter #SQL #SQLQuery #Database #DataEngineering #DeviceManagement
SQL Query to find members of an Active Directory Security Group | https://techygeekshome.info/sql-query-active-directory-group-members/?fsp_sid=10201 | #Guide #SystemCenter #ActiveDirectory #Guide #Microsoft #Query #SQL #SQLQuery #ActiveDirectory #SecurityGroup #BlueskyPlatform #DatabaseManagement #
SQL Query to find members of an Active Directory Security Group - TechyGeeksHome
SQL Query to find members of an Active Directory Security Group - We recently helped out with a data migration which included creating a completely new set of
techygeekshome.info
September 5, 2025 at 3:31 AM
SQL Query to find members of an Active Directory Security Group | https://techygeekshome.info/sql-query-active-directory-group-members/?fsp_sid=10201 | #Guide #SystemCenter #ActiveDirectory #Guide #Microsoft #Query #SQL #SQLQuery #ActiveDirectory #SecurityGroup #BlueskyPlatform #DatabaseManagement #
【決定版】TypeScriptのSQLタグ付きテンプレートリテラルで10種類のSQLiteドライバー全部試す
はじめに TypeScriptのSQLタグ付きテンプレートリテラルを数行で書けて超絶便利だったので、10種類のSQLiteドライバーで試した結果を紹介します。 SQLタグ付きテンプレートリテラル 今回の記事で何回も登場しますが、先にSQLタグ付きテンプレートリテラルだけ紹介します。 type SqlBinding = null | number | string; type SqlQuery = { query: string; bindings: SqlBinding[]; };…
はじめに TypeScriptのSQLタグ付きテンプレートリテラルを数行で書けて超絶便利だったので、10種類のSQLiteドライバーで試した結果を紹介します。 SQLタグ付きテンプレートリテラル 今回の記事で何回も登場しますが、先にSQLタグ付きテンプレートリテラルだけ紹介します。 type SqlBinding = null | number | string; type SqlQuery = { query: string; bindings: SqlBinding[]; };…
【決定版】TypeScriptのSQLタグ付きテンプレートリテラルで10種類のSQLiteドライバー全部試す
はじめに TypeScriptのSQLタグ付きテンプレートリテラルを数行で書けて超絶便利だったので、10種類のSQLiteドライバーで試した結果を紹介します。 SQLタグ付きテンプレートリテラル 今回の記事で何回も登場しますが、先にSQLタグ付きテンプレートリテラルだけ紹介します。 type SqlBinding = null | number | string; type SqlQuery = { query: string; bindings: SqlBinding[]; }; function sql(strings: TemplateStringsArray,... Source link
inmobilexion.com
September 13, 2025 at 2:47 PM
【決定版】TypeScriptのSQLタグ付きテンプレートリテラルで10種類のSQLiteドライバー全部試す
はじめに TypeScriptのSQLタグ付きテンプレートリテラルを数行で書けて超絶便利だったので、10種類のSQLiteドライバーで試した結果を紹介します。 SQLタグ付きテンプレートリテラル 今回の記事で何回も登場しますが、先にSQLタグ付きテンプレートリテラルだけ紹介します。 type SqlBinding = null | number | string; type SqlQuery = { query: string; bindings: SqlBinding[]; };…
はじめに TypeScriptのSQLタグ付きテンプレートリテラルを数行で書けて超絶便利だったので、10種類のSQLiteドライバーで試した結果を紹介します。 SQLタグ付きテンプレートリテラル 今回の記事で何回も登場しますが、先にSQLタグ付きテンプレートリテラルだけ紹介します。 type SqlBinding = null | number | string; type SqlQuery = { query: string; bindings: SqlBinding[]; };…
I've found the ParseResult structure returned from pg_query::parse() to be fairly tedious to navigate and use. I've now created my own structures, the top level called SqlQuery, and a function to convert a ParseResult to a SqlQuery.
August 5, 2025 at 2:33 AM
I've found the ParseResult structure returned from pg_query::parse() to be fairly tedious to navigate and use. I've now created my own structures, the top level called SqlQuery, and a function to convert a ParseResult to a SqlQuery.
What's the most sophisticated query you've written to solve a real-world problem? How did it take advantage of PostgreSQL's capabilities?
#SQL #Postgres #PostgreSQL #OpenSource #Database #SQLquery #Development
#SQL #Postgres #PostgreSQL #OpenSource #Database #SQLquery #Development
November 11, 2025 at 2:39 PM
What's the most sophisticated query you've written to solve a real-world problem? How did it take advantage of PostgreSQL's capabilities?
#SQL #Postgres #PostgreSQL #OpenSource #Database #SQLquery #Development
#SQL #Postgres #PostgreSQL #OpenSource #Database #SQLquery #Development
January 17, 2025 at 11:22 PM
sqlQuery
February 24, 2026 at 9:00 AM
sqlQuery
📦 burnbright/silverstripe-sqlquerylist 3.1.0
Wraps a SilverStripe SQLQuery in a SS_List
🔗 https://github.com/silvershop/silverstripe-sqlquerylist
Wraps a SilverStripe SQLQuery in a SS_List
🔗 https://github.com/silvershop/silverstripe-sqlquerylist
March 4, 2026 at 7:10 PM
📦 burnbright/silverstripe-sqlquerylist 3.1.0
Wraps a SilverStripe SQLQuery in a SS_List
🔗 https://github.com/silvershop/silverstripe-sqlquerylist
Wraps a SilverStripe SQLQuery in a SS_List
🔗 https://github.com/silvershop/silverstripe-sqlquerylist
📦 silvershop/silverstripe-sqlquerylist 3.1.0
Wraps a SilverStripe SQLQuery in a SS_List
🔗 https://github.com/silvershop/silverstripe-sqlquerylist
Wraps a SilverStripe SQLQuery in a SS_List
🔗 https://github.com/silvershop/silverstripe-sqlquerylist
March 4, 2026 at 7:10 PM
📦 silvershop/silverstripe-sqlquerylist 3.1.0
Wraps a SilverStripe SQLQuery in a SS_List
🔗 https://github.com/silvershop/silverstripe-sqlquerylist
Wraps a SilverStripe SQLQuery in a SS_List
🔗 https://github.com/silvershop/silverstripe-sqlquerylist
🚨 EUVD-2026-49640
📊 n/a
📝 SQL injection vulnerability in Dede CMS v.5.7.118 allows a remote attacker to obtain sensitive information via the sqlquery parameter of the sys_sql_query.php component
🔗 https://euvd.enisa.europa.eu/vulnerability/EUVD-2026-49640
#cybersecurity #infosec #cve #euvd
📊 n/a
📝 SQL injection vulnerability in Dede CMS v.5.7.118 allows a remote attacker to obtain sensitive information via the sqlquery parameter of the sys_sql_query.php component
🔗 https://euvd.enisa.europa.eu/vulnerability/EUVD-2026-49640
#cybersecurity #infosec #cve #euvd
July 28, 2026 at 2:01 AM
🚨 EUVD-2026-49640
📊 n/a
📝 SQL injection vulnerability in Dede CMS v.5.7.118 allows a remote attacker to obtain sensitive information via the sqlquery parameter of the sys_sql_query.php component
🔗 https://euvd.enisa.europa.eu/vulnerability/EUVD-2026-49640
#cybersecurity #infosec #cve #euvd
📊 n/a
📝 SQL injection vulnerability in Dede CMS v.5.7.118 allows a remote attacker to obtain sensitive information via the sqlquery parameter of the sys_sql_query.php component
🔗 https://euvd.enisa.europa.eu/vulnerability/EUVD-2026-49640
#cybersecurity #infosec #cve #euvd
How can I check the version and edition of SQL Server installed? via PlanetPowerShell #SQLServer #DatabaseManagement #DataAnalysis #SQLQuery
How can I check the version and edition of SQL Server installed?
********* UPDATE 05/08/2019 ********* It’s been a while (4 years!) since using this script, and have found a few flaws in its logic and execution, especially when it comes to SQL 2000 instances (yes, they’re still very much out there). The script below…
dlvr.it
February 27, 2025 at 6:55 PM
How can I check the version and edition of SQL Server installed? via PlanetPowerShell #SQLServer #DatabaseManagement #DataAnalysis #SQLQuery
Life of a #SQLQuery. Excellent improvements with 1. #Optimizer with #AdaptiveQueryExecution 2. #ExecutionEngine with re-written C+ and ~10X faster (#JVM #Presto) 3. #Caching with fast store 4. #AuxiliaryDataStructure: #DataSkipping with #DeltaLake transactionlog #dataaisummit
November 4, 2024 at 6:26 AM
Life of a #SQLQuery. Excellent improvements with 1. #Optimizer with #AdaptiveQueryExecution 2. #ExecutionEngine with re-written C+ and ~10X faster (#JVM #Presto) 3. #Caching with fast store 4. #AuxiliaryDataStructure: #DataSkipping with #DeltaLake transactionlog #dataaisummit