Skip to content

Sub queries does not use/support columnNameMappers #1131

@kamote

Description

@kamote

Our models have a custom columnNameMapper that convert date values into a timestamp and other custom operations

It works on simple queries

user.query().where('createdAt', '>', '2018-01-01 10:20:20') 
-->  select "users".* from "users" where "createdAt" = 1514802020000 

However it does not work properly on subqueries

model.query()
  .where((builder) => {
    builder.where('createdAt', '2018-01-01 10:20:20')
      .orWhere('createdAt', '>', '2018-01-01 10:20:20');
  })

Actual Query

select "users".* from "users" 
where ("createdAt" = '2018-01-01 10:20:20' or "createdAt" > '2018-01-01 10:20:20')

Expected Query

select "users".* from "users" 
where ("createdAt" = 1514802020000 or "createdAt" > 1514802020000)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions