Insights into Silicon Carbide: Properties, Production, and Prospects