GitHub

Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more

Since Github doesn't provide a great way for you to learn about new releases and features, don't just star the repo, join the mailing list. dsq will likely work on other platforms that Go is ported to ...
GitHub

CSV + JSON Cruncher - query and process your CSV and JSON files using SQL.

A tool which treats CSV and JSON files as SQL tables, performs SQL SELECT queries on them, and stores the result into CSV and JSON files. Many tools and systems can export their data to CSV. Typical ...
IEEE

CCS-SQL: Enhancing Text-to-SQL Framework for Computational Queries via Large Language Models

Abstract: The Text-to-SQL task is to convert natural language queries into Structured Query Language (SQL) to achieve a natural language interface for database queries. The current research on Text-to ...
IEEE

LI-EMRSQL: Linking Information Enhanced Text2SQL Parsing on Complex Electronic Medical Records

Abstract: Converting natural language text into executable SQL queries significantly impacts the healthcare domain, specifically when applied to electronic medical records. Given that electronic ...
Microsoft

Working with date/time values and SQL Server

TL;DR: if you want to use date/time values from a SQL Server table in PowerApps, use the datetimeoffset column type and your life will be easier. The datetime (and friends) column type represent an ...
TechRepublic

SQL basics: Datetime and interval data types

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types. Datetimes and intervals are ...