It’s a long topic, kendashs and q helped me allot as before this had never used jscript/Java and only ever have minimal SQL experience.
With the addition of graphql there are likely improvements removing the need to the SQL queries and improvements but been almost 2 years since we went live with it and other than the odd update for PMS API changes or minor tweaks to account for unforseen events.