Aquas: Enhancing Domain Specialization through Holistic Hardware-Software Co-Optimization based on MLIR (Full Report)