Diaphragm-based microsystems using thin film silicon carbide