SQL
Coverage of SQL in the Nexus archive.
- [India] Is careers-github.com a recruitment scam?
A candidate describes a recruitment process for a remote Data Analyst position involving technical assessments and interviews, followed by a request to pay ₹30,000 for an Advanced PyTorch certification before joining. The candidate suspects a scam due to discrepancies with GitHub's official hiring process and the requirement for upfront payment despite promised reimbursement.
- Show HN: Py-SQL-cleaner – format SQL embedded in Python strings
Py-SQL-cleaner is a CLI tool that detects and formats SQL embedded in Python files without altering Python syntax. It can format SQL in place or extract it into .sql files, avoiding rewriting SQL with runtime parameters or templates.
- SQL patterns I use to catch transaction fraud
The article discusses SQL patterns used to catch transaction fraud. It provides insights into detecting fraudulent transactions using SQL. The article is available on the analytics website.
- SQL: Incorrect by Construction
The article discusses SQL and its construction, with a comments section on Y Combinator. It has 2 comments and 10 points.
- Database world trying to build natural language query systems again – this time with LLMs
Database and analytics vendors are leveraging large language models (LLMs) to develop natural language query systems, aiming to make data queries more accessible beyond SQL. While Text-to-SQL tools are seen as beneficial for analysts and DBAs, the article cautions against assuming general user adoption will be seamless.
- ggsql: A Grammar of Graphics for SQL
Posit has released ggsql, an alpha-stage tool that applies the Grammar of Graphics concept to SQL, aiming to simplify query building for data analysts and developers. The tool is designed to streamline SQL workflows through a declarative approach.