The basic features of Daffodil DB under Data Query Language (DQL) are:

• Multi Table Joins Cross Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Cost-Based Query Optimizer
• On-Line Query Statistics
• Predicates: Comparison, In, Like, Between
• Aggregates ( Count, Sum, Max, Min, Avg)
• Correlated Sub queries