How to model a Bayesian network or, more generally, a directed weighted graph, in SQL?

create table node (
  id int not null auto_increment,
  name TEXT
)

create table edge (
  from_node int not null,
  to_node int not null,
  weight float
)