[raster] ST_Transform & ST_Resample are confusing
Users expect to use ST_Transform to reproject to a new srid and they want to be able to define the alignment of the new grid at the same time. However this is now possible only with ST_Resample.
ST_Transform should accept more alignment parameters and ST_Resample should not have a srid parameter.
I understand that those two functions are very much aligned on what GDAL provides but gdalwarp is itself very confusing. We don't want to reproduce this confusion.