Given either a numeric id or name, returns all the children of that reference from sql. If the numeric id is given a normal select is done, if the name is given a subselect to get the id is done.

ref.clj

(defn get-reference-children
    [fn-id] ;fullname-or-id
    (-> (select* reference)
        (fields :id :fullname :isDir )  
        (#(if-not (string? fn-id)       
            (where %1 {:parent_id fn-id})   
            (where %1 {:parent_id (subselect reference
                                      (fields :id)                    
                                      (limit 1)                       
                                      (where {:fullname fn-id}))} ))) 
        (exec)))