Games TypeORM Builder Bench

Builder Bench

Building versus sending, joins, entities or raw rows, parameters, Brackets, paging and picking columns.

0 / 7 levels · 0 / 21 ★Start playing ›

  1. Builder Bench

    The QueryBuilder is a workbench. Each call such as where() or leftJoin() adds a part to one SQL statement on the bench. Nothing leaves the bench until you call a get or execute method; then the whole statement is sent and you get entities or raw rows back.

Your rulebook

Finish a level to add its rule. Fill the book and you can explain all of this in an interview.

  1. 1Finish Nothing is sent while you build to unlock this rule.
  2. 2Finish Join to fill, or join to filter to unlock this rule.
  3. 3Finish Entities or raw rows to unlock this rule.
  4. 4Finish Parameters, not glue to unlock this rule.
  5. 5Finish Where OR goes to unlock this rule.
  6. 6Finish take() pages authors, limit() cuts rows to unlock this rule.
  7. 7Finish Pick only the columns you need to unlock this rule.