For much bigger application exposing a column is a challenge and options to try from PEGA UI as developer is not a good solution and need to try following options we have which will run on DB directly and can be much much faster.
Consolidating the articles i had gone through for the possible solutions to try for exposing column and populating data from BLOB
Thank you for sharing your idea here in the Pega Collaboration Center (PCC)!
I have submitted this idea on your behalf in our internal system for feature enhancements and updated your post with the associated FDBK-ID. You can take this ID to your Account Executive for next steps.