typeorm mssql code example

Example 1: typeorm

npm install typeorm -g
typeorm init --name MyProject --database mysql

Example 2: typeorm tosql

const sql = connection.createQueryBuilder()
    .select("user")
    .from(User, "user")
    .where("user.id = :id", { id: 1 })
    .getSql();