Materials design of perovskite solid solutions for thermochemical applications