To date I am re-inventing the wheel within probably the most uncomfortable way. I'm able to feel during my stomach this will break eventually and cause me lots of discomfort. Therefore I am searching for an easy method to consider articles alias and make either recption menus item url or even the article url. Exist no joomla api calls which make this simpler/cleaner/more future-proof?

/* Find article by alias */
$db =& JFactory::getDBO();
$sql = 'select id from #__content where alias=' . "'$alias'";
$db->setQuery($sql);
$row = $db->loadAssoc();
$artId = $row['id'];
if ($artId != null) {
  $artLink = 'index.php?option=com_content&view=article&id='.$artId;
  /* Find menu item by article id */
  $sql = 'select parent,alias from #__menu where link=' . "'$artLink'";
  $db->setQuery($sql);
  $row = $db->loadAssoc();
  $menuLink = '';
  while ($row != null) {
    $menuLink = '/' . $row['alias'] . $menuLink;
    $sql = 'select parent,alias from #__menu where id=' . $row['parent'];
    $db->setQuery($sql);
    $row = $db->loadAssoc();
    }
  $menuLink = 'index.php' . $menuLink;
  }

$articleUrl = ($menuLink != '') ? 'index.php' . $menuLink : JRoute::_($artLink);

Use JRoute? Presuming you are still beginning by having an alias, a far more 'Joomla' way do this may be something similar to:

/* Find article by alias */
$db =& JFactory::getDBO();
$sql = 'select id from #__content where alias=' . $db->quote($alias);
$db->setQuery($sql);
$row = $db->loadAssoc();
$artId = $row['id'];
if ($artId != null) {
  $articleUrl = JRoute::_('index.php?option=com_content&view=article&id=' . $artId);
}

Paperwork for JRoute here: http://api.joomla.org/Joomla-Framework/JRoute.html

This will get around SQL getting away issues you could get if there have been quotes inside your alias o

I ought to also point out that if you would like recption menus link particularly - you must have the '&itemid=' bit around the finish from the path passed to JRoute! Obviously, you cannot have that itemid in the alias - there might be multiple menu products pointed towards the same article ).