ts-sql-query is a type-safe query builder that provides a way to build dynamic SQL queries in a type-safe way, that means, the TypeScript compiler verifies the queries. Type-safe SQL means the ...

create table query_stat_log as select 1 as seq_num,now() as ts,* from query_stat_time; create index query_stat_log_seq_num_key on query_stat_log(seq_num); create index query_stat_log_ts_key on ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

I first came across the Value.NativeQuery() M function about six months ago, but it didn’t do anything useful then so I didn’t blog about it. I checked it again recently though and now it does ...

Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...