my ($pid) = $db->query(<<END_SQL, $property)->list;

    SELECT `id` FROM `table2` WHERE `property` = ?

END_SQL

    if (not $pid) {
        $db->query("INSERT INTO `table2` (`property`) VALUES (?)", $property);
        $pid = $db->last_insert_id();
    }