Add custom SQL field for Views

[jaumard]

My use case here is that I have a huge table with billions of entries. To improve a bit performance I want a view with let say the data since two years only. By allowing a custom field where I can add a custom SQL I would be able to do that.
Hope that's clear enough ^^ or let me know

[schultek]

So would a custom additional field to the SELECT portion of the query enough or do you want to du custom joins also?

[schultek]

There is also something experimental called Transformers, that I added for a custom use-case. These do not create a new field, but 'transform' an existing, e.g. filtering or aggregating a list, performing a calculation etc.
Maybe this can be extended to allow arbitrary statements. But those too only are applied to the SELECT part.

[jaumard]

So for my specific use case it would be more a WHERE clause.
Example, currently we have this generated:

CREATE VIEW fake_models_view AS 
SELECT "fake_models".*
FROM "fake_models"
WHERE '_#07c2fe9ce829535a5eed01abe7b2eaa32ac021cb#_' IS NOT NULL;

I would like to be able to do something like:

CREATE VIEW fake_models_view AS 
SELECT "fake_models".*
FROM "fake_models"
WHERE '_#07c2fe9ce829535a5eed01abe7b2eaa32ac021cb#_' IS NOT NULL
 AND created > DATEADD(yy,-2,GETDATE());

Something like this.

Transformers looks interesting also :D

[schultek]

But cant you do the where using the QueryParams object?

[jaumard]

I can but I'll have to think of adding it in all QueryParams of the projects where by doing it here it's once for the all project and all queryparam I'll do would be about business logic and not about making the date lighter