A little while ago, I saw a post like this on X. 「最近ORMばかりで、生のSQLを書く機会がほとんどない。」 It is true that thanks to ORMs like Prisma, I rarely write raw SQL in my daily work anymore. However, I am the type of ...

SQL (Structured Query Language) is the standard language used to talk to relational databases. You use it to create databases/tables, insert data, retrieve data, update data, and delete data.

To execute the 8 operational queries in this project, I utilized 8 tables across the Sales, Production, and Purchasing schemas. Below is a targeted data dictionary of the exact fields used in my ...