Postgresql – Typeorm queryBuilder select only a specific key value of a JSONB type column
Let's say i've a simple queryBuilder like: const workout = await this.workouts .createQueryBuilder('workout') .select(['workout.uuid', `workout.name ->> 'it'` as name]) .where('workout.uuid = :workoutUuid', { workoutUuid }) .getOne(); return workout; By using getRawOne() i see that typeorm is correctly taking the value…