ORM return all fields

[mybigman]

How can I return all fields without specifying every one? Some of our vendor tables have 100+ columns :/

I can use serializeExtras but the problem with that it moves everything under meta and not the root which is problematic where some of the defined columns are at root level whilst the rest are under meta

public serializeExtras = true

Is there a clean way of handling this?

[feniljariwala82]

Can you please share your model code here, because when you query "Model.all()" it will fetch all the columns except "password". So I request you to share your code so that I can help you out.

[mybigman]

Model.all() returns all rows not all fields.

import { BaseModel, column, HasOne, hasOne } from '@ioc:Adonis/Lucid/Orm'

export default class Order extends BaseModel {
  public static table = 'mytable'

  // public serializeExtras = true

  @column({ isPrimary: true })
  public orderId: number
}

[tsulatsitamim]

If you don't need relationship you can use Database Query Builder instead of Model.
you still can use join if needed

[legawa4201]

Im also facing this issue why we put the $extras column inside a meta object? I personally think this is a weird design decision

[RomainLanz]

Im also facing this issue why we put the $extras column inside a meta object? I personally think this is a weird design decision

What's the issue you are having?