Use Model without specifying columns of table?

[Uttam-EWW]

So basically, I want to use model object for querying but without specifying all columns of table.
I tried this approach but I couldn't execute it. I below errors.

So is there any way to use model without specifying columns?
Thanks.

[Barbapapazes]

Hello, can you provide more informations and a snippet of code?

[Barbapapazes]

Yep, you can use the query builder!

import Database from '@ioc:Adonis/Lucid/Database'

Database.from('compagny').select('*').first()

I think the code snippet above can help you!

[Uttam-EWW]

I know about this way, but can not access other model methods, like firstOrCreate, updateOrCreate, etc.

[Barbapapazes]

And how a model can have no columns but data in database? It seems to be a strange case!

[Uttam-EWW]

of course there is columns in database, but just don't want write it down in model.

[carlmathisen]

@Uttam-EWW There's a lot of useful "magic" in Lucid models, which can only work optimally if the model is configured properly. If you don't want to configure the models, then you're better off just doing a regular query with the Database query builder like @Barbapapazes suggested.