Support dbReadFunction and dbWriteFunction column annotations to apply SQL functions:
<metadata>
	<table name="pois" alias="poi" role="Parent">
		<column name="geometry" dbReadFunction="ST_AsText" dbWriteFunction="ST_GeomFromText"/>
	</table>
</metadata>

Limitations: SELECT clause must use qualified name, search & replace can potentially replace too much.