@JoiceJacob What is the source? If RDBMS, Dremio will just push down query written. You can create a view and add column you need in the filter. I am not entirey following your question.
If the backend is Iceberg table format there is a concept called partition transform which can help
Kindly let me know the source and if you have a job profile and we can start there