sql query typo
view for quick lookups of pilots by user (or users by pilot), since that typically involves joining through the keys if done manually
basic update method for skill plans, with checks to ensure only owner can update, and that any change in the 'share as pilot' reference only goes to pilots associated with the current user